Adjusting the order of Definition Queries

07-15-2020 12:58 PM
Status: Open
Labels (1)
New Contributor III

I would like the ability to change the order of definition queries. I created multiple definition queries in ArcGIS Pro but not in the order that I wanted the queries to appear in the dropdown menu. To have the queries in the right order, I would have to recreate them in the appropriate order. 


@ElenaS I too have the same problem, the only way I have gotten around it is to save each query expression to a file, delete all of the queries from the layer, rename the .exp files that you saved to reflect the order that you want, then use the "Add definition queries from files..." method (it is on the drop down for "New definition query"). When the dialog comes up to pick your file(s), you will already have them in order based on how you renamed them, so you pick the first file, hold down your shift key, and then choose the last file. Alternatively, you can also use your CTRL key to pick the order that you want, even if you didn't rename the .exported .exp files. This way you can keep the name of the query like you want it to show as in the list, and you can specify the order from how you pick them.


Agree with @ElenaS

💡Would like the functionality to manually sort Definition Queries (click, drag) or else alphabetize (by Query name) in the Data/Definition Query drop-down list. 

In addition, would like the functionality to AUTO-Zoom to Selection from drop-down list. For example, the list contains queries selecting City Parks by Name (alphabetically, hopefully) and when a particular City Park name is selected from the list, the map will automatically Zoom To Selection on that City Park layer. 






@RandyWeaver: Oh, smart! I'll definitely use that next time.

@pkorst_coa: I agree an auto-zoom feature would be nice. Rather than Zoom to Selection though, Zoom to Layer might be more relevant to avoid an additional step (selection).

Also, in case it helps, I added the Zoom To Layer command into my Quick Access Toolbar to make it a little bit more accessible for now.