Select to view content in your preferred language

Duplicate Definition Query

999
4
07-31-2022 05:57 PM
Status: Under Consideration
Labels (1)
Drew_Sutton
New Contributor III

The ability to have multiple definition queries associated with a layer is great. However, to streamline the ability to copy a currently definition query so it can be changed would be great. Adding a duplicate definition query button along side the load, save and remove definition query buttons (unlined in red in attached image) would be helpful.

Currently you have to edit the current definition query, copy the SQL, create a new definition query, paste the SQL and update the definition query. Adding a duplicate definition query button would allow the use to quickly and easily duplicate the definition query and update the duplicated version straight away.

Drew_Sutton_0-1659315281064.png

4 Comments
Marie_Ducharme

Totally! Absolutely. Glad you wrote this suggestion up Drew! I have been thinking the same for months.

TanuHoque
Status changed to: Under Consideration
 
CA_SC_-_EricBall__GISS_

absolutely!

wayfaringrob

Here's a scenario where this would have saved me many, many clicks:

rburke_1-1678822680669.png

These queries will make for easy mapping with this layer at various scales in the future.

I'm also imagining if I had made a mistake here, just how frustrating that would be. It would be even better, for scenarios like this one, if it were "smart" like Excel and provided a way to increment your queries and query names or make batch edits once created. A batch/related query editor, maybe?

I also noticed that you can't rearrange queries in the list, and the fact that they name themselves nominally ("Query 1") doubles the work, but I have a related idea open for that, too: More intuitive default definition query naming - Esri Community