Ability to query text field in Pro as with ArcMap

756
4
08-06-2019 05:24 AM
Status: Implemented
Labels (1)
PhilippeLeblanc
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.

4 Comments
KoryKramer

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.

KoryKramer
Status changed to: Under Consideration
 
KoryKramer
Status changed to: In Product Plan
 
KoryKramer
Status changed to: Implemented

This is implemented in ArcGIS Pro 2.9.  See Ideas in ArcGIS Pro 2.9 or go directly to 5:00 in the video for a quick demo.