topic Dynamically choosing a SQL expression parameter in Model Builder? in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/dynamically-choosing-a-sql-expression-parameter-in/m-p/253392#M8690 <HTML><HEAD></HEAD><BODY><P style="color: #242729; background-color: #f9f8f6; border: 0px; margin: 0px 0px 1em;">I have a working model in Arcmap 10.3 that creates a feature class data from CSV file, queries the data according to a SQL Expression, and then conducts many spatial joins.</P><P style="color: #242729; background-color: #f9f8f6; border: 0px; margin: 0px 0px 1em;">The model works as expected, but I want to make the SQL Expression as easy as possible for users to enter who do not know SQL.</P><P style="color: #242729; background-color: #f9f8f6; border: 0px; margin: 0px 0px 1em;">How can I make the Query Builder window for this parameter reference the feature class so that the user can use the "Get Unique Values" button rather than entering field names?</P><P style="color: #242729; background-color: #f9f8f6; border: 0px; margin: 0px 0px 1em;">As it is currently, the Query Builder window has no fields to choose from, which leaves it up to user to know the field names and correct SQL syntax.</P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/451679_pastedImage_2.png" /></P></BODY></HTML> Thu, 27 Jun 2019 16:31:34 GMT EnvironmentalIntelligence 2019-06-27T16:31:34Z Dynamically choosing a SQL expression parameter in Model Builder? https://community.esri.com/t5/geoprocessing-questions/dynamically-choosing-a-sql-expression-parameter-in/m-p/253392#M8690 <HTML><HEAD></HEAD><BODY><P style="color: #242729; background-color: #f9f8f6; border: 0px; margin: 0px 0px 1em;">I have a working model in Arcmap 10.3 that creates a feature class data from CSV file, queries the data according to a SQL Expression, and then conducts many spatial joins.</P><P style="color: #242729; background-color: #f9f8f6; border: 0px; margin: 0px 0px 1em;">The model works as expected, but I want to make the SQL Expression as easy as possible for users to enter who do not know SQL.</P><P style="color: #242729; background-color: #f9f8f6; border: 0px; margin: 0px 0px 1em;">How can I make the Query Builder window for this parameter reference the feature class so that the user can use the "Get Unique Values" button rather than entering field names?</P><P style="color: #242729; background-color: #f9f8f6; border: 0px; margin: 0px 0px 1em;">As it is currently, the Query Builder window has no fields to choose from, which leaves it up to user to know the field names and correct SQL syntax.</P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/451679_pastedImage_2.png" /></P></BODY></HTML> Thu, 27 Jun 2019 16:31:34 GMT https://community.esri.com/t5/geoprocessing-questions/dynamically-choosing-a-sql-expression-parameter-in/m-p/253392#M8690 EnvironmentalIntelligence 2019-06-27T16:31:34Z