topic How to build a SQL expression in Python in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/how-to-build-a-sql-expression-in-python/m-p/416208#M14069 <HTML><HEAD></HEAD><BODY><SPAN>In light of ArcGIS Server not recognizing the "Query Builder" wizard when using the Select By Attributes tool, I'm wondering if there is a way to manually construct the Query Builder?&nbsp; So for instance, (see attached picture) based on the user first selecting which feature layer they want to run query against, a second dropdown list would then show All the Attributes associated with that feature layer.&nbsp; A third dropdown list would then contain the values from which attribute the user chose.&nbsp; So for example, If I wanted to run this Query "Active" = 'N' on the Wells layer.&nbsp; Does anyone have any python to get me started here?</SPAN><BR /><BR /><SPAN>many thanks</SPAN></BODY></HTML> Tue, 05 Oct 2010 18:51:39 GMT JoshV 2010-10-05T18:51:39Z How to build a SQL expression in Python https://community.esri.com/t5/geoprocessing-questions/how-to-build-a-sql-expression-in-python/m-p/416208#M14069 <HTML><HEAD></HEAD><BODY><SPAN>In light of ArcGIS Server not recognizing the "Query Builder" wizard when using the Select By Attributes tool, I'm wondering if there is a way to manually construct the Query Builder?&nbsp; So for instance, (see attached picture) based on the user first selecting which feature layer they want to run query against, a second dropdown list would then show All the Attributes associated with that feature layer.&nbsp; A third dropdown list would then contain the values from which attribute the user chose.&nbsp; So for example, If I wanted to run this Query "Active" = 'N' on the Wells layer.&nbsp; Does anyone have any python to get me started here?</SPAN><BR /><BR /><SPAN>many thanks</SPAN></BODY></HTML> Tue, 05 Oct 2010 18:51:39 GMT https://community.esri.com/t5/geoprocessing-questions/how-to-build-a-sql-expression-in-python/m-p/416208#M14069 JoshV 2010-10-05T18:51:39Z