Saved Queries allow users to save search criteria and additional formatting options to keep your data just the way you like it.
What are Saved Queries
Saved Queries are capable of saving the following information so you can quickly return to, or even set default, views for tables.
Search Filters
Sort Directions
Visible/Hidden columns
Column Order
Column Sizes
For example in the below screenshot we have a saved query applied for the Environment History Report called Production. This Saved Query applies a filter on Environment for “Prod“ and sorts on the Requested On column.
By default, the last Saved Query we were viewing on a page will be restored when coming back. Meaning this Production query will be applied to this page indefinitely.
Creating a Saved Query
In order to create a Saved Query perform the following:
1️⃣ Apply any filters, sorts, or column altering you would like to be saved.
2️⃣ Click on the Select a saved query dropdown and click the Add Query button.
3️⃣ Give your Saved Query a meaningful name, this is how you will identify it later.
At any point, we can now return to this table and easily apply this Saved Query.
Your previously selected Saved Query will also be remembered so if you were to log out of the application and come back the same Saved Query will be selected.
Modifying a Saved Query
1️⃣ In order to modify a Saved Query it must first be selected.
2️⃣ With the Query selected, modify the filters, sorts, and columns as you normally would.
Notice the query name is now italic For Docs. This indicates changes have been made to the query.
3️⃣ Click on the Save Icon to the right of the Saved Query dropdown to save your changes.
Alternatively you can also undo the changes by clicking the Undo Icon to the left. This will reset the Saved Query to its original state.
Pro Tip
You can easily duplicate queries by simply selecting the one you wish to copy and then clicking the Add Query button again and providing a new name.
Changing the Query Name
1️⃣ To change the name of a Saved Query click the Select a saved query dropdown
2️⃣ Click the menu options on the right side of the Query you want to rename
3️⃣ Select the rename option and provide a new name
Recommended Reading
Take a look at the Data Table documentation to learn how to get the most out of Saved Queries.
FAQ
Can you share Saved Queries?
While this is on our roadmap, you can not presently share Saved Queries across users.
My Query shows as dirty even after undoing changes
Sometime this can occur between releases if the column names change. In this case you can freely save the query updates to accept the new column name.