- tl;dr
- Hotkeys
Query Manager keeps track of your query history and bookmarks in Studio 3T.
Query History
Search query history - Ctrl + F (⌘+ F)
Select query - Enter
Remove selected query - Delete (Fn + Backspace)
Clear query history - Shift + Delete (Shift + Fn + Backspace)
Bookmarks
Search bookmarks - Ctrl + F (⌘+ F)
Select bookmark - Enter
Edit selected bookmark - Ctrl + E (⌘ + E)
Remove from query history - Delete (Fn + Backspace)
Clear query history - Shift + Delete (Shift + Fn + Backspace)
You can find the History and Bookmarks tabs under Query Manager, which you can access in SQL Query, IntelliShell, Aggregation Editor, and the Collection Tab.
Bookmark a query
1. Run a query in SQL Query, IntelliShell, Aggregation Editor, or the Visual Query Builder.
2. Click on the star icon at the top-right corner.
3. Name the bookmark.
4. Click OK.
View bookmarked queries
1. While in SQL Query, IntelliShell, Aggregation Editor, or the Collection Tab, click on the down arrow next to the star icon and choose Bookmark Manager.
2. This will open the Bookmarks tab in the Query Manager where you can see all your bookmarks.
From here, you can select the bookmark to run the query, edit the bookmark, or select the bookmark as the default query.
Note that you can only see the bookmarks that were created within a particular feature. For example, the SQL Query Manager will only show bookmarked SQL queries. It won’t include bookmarks you’ve created in Aggregation Editor, IntelliShell, or Visual Query Builder.
View your query history
1. While in SQL Query, IntelliShell, Aggregation Editor, or the Collection Tab, click on the ellipsis icon.
2. This will open the History tab in Query Manager.
From here, you can search through your history, order queries by execution date and time, and of course, select a query to be run.
Like bookmarks, you can only see the query history for a particular feature. For example, the SQL Query Manager will only list SQL queries, not aggregation or find queries.
