ORDER BY clause in definition queries
1123
2
06-22-2022 06:01 PM
by
It would be helpful if we could use the ORDER BY clause in definition queries.
Like this:
That would be useful for scenarios where we want to control sorting in ways that can't be done in the attribute table UI, but can be done in the DB, such as making nulls come last in a column:
https://community.esri.com/t5/arcgis-pro-ideas/sorting-a-field-in-the-attribute-table-specify-how/id....
There are other scenarios too.
If it's not possible to do it right in the definition query SQL expression builder textbox, then it could be done in its own ORDER BY expression builder textbox.
Using the ORDER BY clause in other enterprise systems, such as IBM Maximo, has been really handy. It would be great if we could do it in ArcGIS Pro too.
2 Comments
