idea Ability to query text field in Pro as with ArcMap in ArcGIS Pro Ideas

Ability to query text field in Pro as with ArcMap

PhilippeLeblanc — Tue, 06 Aug 2019 12:24:16 GMT

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.

Re: Ability to query text field in Pro as with ArcMap

KoryKramer — Tue, 17 Sep 2019 15:13:01 GMT

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.

Re: Ability to query text field in Pro as with ArcMap - Status changed to: Under Consideration

KoryKramer — Fri, 19 Feb 2021 22:46:01 GMT

Re: Ability to query text field in Pro as with ArcMap - Status changed to: In Product Plan

KoryKramer — Tue, 01 Jun 2021 17:46:47 GMT

Re: Ability to query text field in Pro as with ArcMap - Status changed to: Implemented

KoryKramer — Fri, 12 Nov 2021 00:19:45 GMT

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