topic Re: ArcPy SelectLayerByAttribute_management with a domain in Python Questions https://community.esri.com/t5/python-questions/arcpy-selectlayerbyattribute-management-with-a/m-p/368778#M29070 <HTML><HEAD></HEAD><BODY><P>Yep. 'Love&nbsp;me a good ol' over-thinking session.&nbsp; Then when it's over, simple wins!</P></BODY></HTML> Thu, 30 Apr 2020 21:28:03 GMT JoeBorgione 2020-04-30T21:28:03Z ArcPy SelectLayerByAttribute_management with a domain https://community.esri.com/t5/python-questions/arcpy-selectlayerbyattribute-management-with-a/m-p/368772#M29064 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I want to subset my database and when I tried&nbsp;</P><P>arcpy.SelectLayerByAttribute_management ("OHlyr3", "NEW_SELECTION", " [SUBTYPECD]" LIKE \'%Overhead\' )&nbsp;</P><P>I was getting an error on the sql expression. Than I found out the field "<SPAN>SUBTYPECD" is really a domain.&nbsp;</SPAN></P><P></P><P><SPAN>What I need is to query against part of it's value like Overhead where I have "Single Phase Overhead" as a domain value&nbsp; It's coded number is 2 if that's easy.&nbsp;</SPAN></P><P></P><P><SPAN>Any ideas?</SPAN></P><P><SPAN>&nbsp;</SPAN></P></BODY></HTML> Thu, 30 Apr 2020 19:03:01 GMT https://community.esri.com/t5/python-questions/arcpy-selectlayerbyattribute-management-with-a/m-p/368772#M29064 BillChappell 2020-04-30T19:03:01Z Re: ArcPy SelectLayerByAttribute_management with a domain https://community.esri.com/t5/python-questions/arcpy-selectlayerbyattribute-management-with-a/m-p/368773#M29065 <HTML><HEAD></HEAD><BODY><P><EM><SPAN style="background-color: #ffffff;">I found out the field "</SPAN><SPAN style="background-color: #ffffff; border: 0px;">SUBTYPECD" is really a domain.&nbsp;</SPAN></EM></P><P></P><P><SPAN style="background-color: #ffffff; border: 0px;">The field isn't a domain, it's a field that is controlled by a domain.&nbsp; What happens if you write your query like this:</SPAN></P><P></P><PRE class="lia-code-sample line-numbers language-none"><CODE>select = 'SUBTYPECD = 2' arcpy.SelectLayerByAttribute_management ("OHlyr3", "NEW_SELECTION", select) <SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Sat, 11 Dec 2021 17:05:50 GMT https://community.esri.com/t5/python-questions/arcpy-selectlayerbyattribute-management-with-a/m-p/368773#M29065 JoeBorgione 2021-12-11T17:05:50Z Re: ArcPy SelectLayerByAttribute_management with a domain https://community.esri.com/t5/python-questions/arcpy-selectlayerbyattribute-management-with-a/m-p/368774#M29066 <HTML><HEAD></HEAD><BODY><P>What an interesting question, I was trying to wrap my head around that!</P><P>Can you just work out which domains contain 'Overhead'?</P><P>eg if overhead appears in coded value 2,4,9 and 10:</P><P><SPAN style="display: inline !important; float: none; background-color: #ffffff; color: #3d3d3d; font-family: inherit; font-size: 100%; font-style: inherit; font-variant: normal; font-weight: inherit; letter-spacing: normal; orphans: 2; overflow-wrap: break-word; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;"> "[SUBTYPECD]" IN (2, 4 ,9, 10)</SPAN></P><P><SPAN style="display: inline !important; float: none; background-color: #ffffff; color: #3d3d3d; font-family: inherit; font-size: 100%; font-style: inherit; font-variant: normal; font-weight: inherit; letter-spacing: normal; orphans: 2; overflow-wrap: break-word; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;">I also believe the query should be passed as a string in itself, ie:</SPAN></P><P></P><P><SPAN style="display: inline !important; float: none; background-color: #ffffff; color: #3d3d3d; font-family: inherit; font-size: 100%; font-style: inherit; font-variant: normal; font-weight: inherit; letter-spacing: normal; orphans: 2; overflow-wrap: break-word; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;">query = '&nbsp;"[SUBTYPECD]" IN (2, 4 ,9, 10) '</SPAN></P><P><SPAN style="display: inline !important; float: none; background-color: #ffffff; color: #3d3d3d; font-family: inherit; font-size: 100%; font-style: inherit; font-variant: normal; font-weight: inherit; letter-spacing: normal; orphans: 2; overflow-wrap: break-word; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;">arcpy.SelectLayerByAttribute_management ("OHlyr3", "NEW_SELECTION", query )&nbsp;</SPAN></P><P></P><P><SPAN style="display: inline !important; float: none; background-color: #ffffff; color: #3d3d3d; font-family: inherit; font-size: 100%; font-style: inherit; font-variant: normal; font-weight: inherit; letter-spacing: normal; orphans: 2; overflow-wrap: break-word; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;">hope this helps</SPAN></P></BODY></HTML> Thu, 30 Apr 2020 20:00:38 GMT https://community.esri.com/t5/python-questions/arcpy-selectlayerbyattribute-management-with-a/m-p/368774#M29066 DavidPike 2020-04-30T20:00:38Z Re: ArcPy SelectLayerByAttribute_management with a domain https://community.esri.com/t5/python-questions/arcpy-selectlayerbyattribute-management-with-a/m-p/368775#M29067 <HTML><HEAD></HEAD><BODY><P>I started typing before you replied Joe, honest!</P></BODY></HTML> Thu, 30 Apr 2020 20:02:02 GMT https://community.esri.com/t5/python-questions/arcpy-selectlayerbyattribute-management-with-a/m-p/368775#M29067 DavidPike 2020-04-30T20:02:02Z Re: ArcPy SelectLayerByAttribute_management with a domain https://community.esri.com/t5/python-questions/arcpy-selectlayerbyattribute-management-with-a/m-p/368776#M29068 <HTML><HEAD></HEAD><BODY><P>The beauty of this forum!&nbsp;&nbsp;<IMG src="https://community.esri.com/legacyfs/online/emoticons/laugh.png" /></P></BODY></HTML> Thu, 30 Apr 2020 20:06:15 GMT https://community.esri.com/t5/python-questions/arcpy-selectlayerbyattribute-management-with-a/m-p/368776#M29068 JoeBorgione 2020-04-30T20:06:15Z Re: ArcPy SelectLayerByAttribute_management with a domain https://community.esri.com/t5/python-questions/arcpy-selectlayerbyattribute-management-with-a/m-p/368777#M29069 <HTML><HEAD></HEAD><BODY><P>This works, it's the simple solution that I overlooked. Instead I tried 20 different ways screwing around with the quotes and backslashes that just confused me. Thanks.</P></BODY></HTML> Thu, 30 Apr 2020 21:19:52 GMT https://community.esri.com/t5/python-questions/arcpy-selectlayerbyattribute-management-with-a/m-p/368777#M29069 BillChappell 2020-04-30T21:19:52Z Re: ArcPy SelectLayerByAttribute_management with a domain https://community.esri.com/t5/python-questions/arcpy-selectlayerbyattribute-management-with-a/m-p/368778#M29070 <HTML><HEAD></HEAD><BODY><P>Yep. 'Love&nbsp;me a good ol' over-thinking session.&nbsp; Then when it's over, simple wins!</P></BODY></HTML> Thu, 30 Apr 2020 21:28:03 GMT https://community.esri.com/t5/python-questions/arcpy-selectlayerbyattribute-management-with-a/m-p/368778#M29070 JoeBorgione 2020-04-30T21:28:03Z