Table: Select by attributes list most recent

1567
6
07-02-2021 06:25 AM
Status: Already Offered
Labels (1)
JakeKrall
Occasional Contributor III

When selecting by attributes in a table view retain the most recent query's in a list in the blank space below the Invert Where Clause check box.  Similar to the Tools geoprocessing Recent section.  And, when retain last used query when the select by attributes tool is opened again.  Making a selection using this tool, then close the tool, upon reopening to make a change in the query the query has to be started from scratch again.

6 Comments
jcarlson

This is an AWESOME idea.

KoryKramer
Status changed to: Needs Clarification

Thanks for submitting this idea @JakeKrall 

It is definitely related to https://community.esri.com/t5/arcgis-pro-ideas/remember-querys/idi-p/923076

But since you refer specifically to Select by Attributes and asking for the most recent query, if I'm understanding correctly, you are asking for this: https://community.esri.com/t5/arcgis-pro-ideas/keep-previous-select-by-attributes-in-geoprocessing-w...

Please confirm and if so, we'll merge the idea.

Thanks

KoryKramer
Status changed to: Open

From Jake:

"Yes, the same idea plus I want to keep a list of the most recent queries like Geoprocessing does.  Thank you sir."

Thanks for the response, Jake.  So you're saying that you want the last query to stay populated AND you also want a Recent list in the Select by Attributes dialog (which would essentially be the place where you would find an implementation of the remember querys to be most helpful to you.  Is that correct?

Please respond as a comment instead of email so we can keep the conversation on this thread.

Thank you!

 

JakeKrall

@KoryKramer Yes, keep a list in the Select by Attributes dialog of most recent query's.  For long query statements, allow hovering with the mouse over each one in the list to show the entire query/sql statement.  Additionally, date/time of last run would help too.

beachcamp

Yes please. From a convenience and efficiency standpoint this would be so nice to have.

JonathanNeal
Status changed to: Already Offered

@JakeKrall We should have this one sort of implemented in 3.0.  We didn't always want previous queries to be added as some fields will be invalid in the new data.  The Floating window tools will check the project history for a match.  If there is a match, the queries done against the layer will be added.