ORDER BY clause in definition queries

Bud — Mon, 02 Sep 2024 07:11:35 GMT

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/idi-p/1184709/jump-to/first-unread-message.
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.

Re: ORDER BY clause in definition queries - Status changed to: Under Consideration

TanuHoque — Fri, 30 Jun 2023 20:58:16 GMT

Re: ORDER BY clause in definition queries

Bud — Mon, 12 Feb 2024 19:13:01 GMT

idea ORDER BY clause in definition queries in ArcGIS Pro Ideas

ORDER BY clause in definition queries

Re: ORDER BY clause in definition queries - Status changed to: Under Consideration

Re: ORDER BY clause in definition queries