Ability to query text field in Pro as with ArcMap

08-06-2019 05:24 AM
Status: Open
Labels (1)
New Contributor II

When we use Select by Attributes for example, in Clause mode of the Query Builder, the choice of expressions depends on the field type because ArcGIS Pro is context-sensitive. We often need to make selection on data which are string field. If we want to select values that are greater than «>», we need to select «is equal to» and after switch to the SQL mode and replace manually «=» with «>». In ArcMap, the option was available directly in the SQL query builder. We would like to have all the expressions for string fields in Clause mode of the Query Builder in ArcGIS Pro that were in ArcMap. Those query are now only possible if we are writing our own SQL query which is time consuming.

1 Comment

Are all of the data in the string field numbers?  Like in my example here where GNIS_ID is a string(10) field but the actual data are numbers so operations like <, >, etc,. make sense:

For now, as a workaround, I guess you would use the benefits of the query builder to build the expression with an available operator, then switch to SQL mode and change the operator.