In the Devo web application, select Data Search → Query History to browse the most recent queries and filter for the queries used during a specific time period.
You can perform the following operations in the Query History area:
Some of these tasks can be performed only on your own queries because they imply a change in the status of the query. It is the case of those tasks related to blocking, the aliased finder and favorites.
The rest of the tasks are meant for information check and can be performed on any query regardless of the person who originally run it. It is the case of filtering, opening and copying.
Block or unblock a query
Select theicon in the required query row to block it, avoiding any modification in the query. Click the icon again to unblock the query.
See Block a query to learn more.
Add or remove a query to or from your aliased finder
Select theicon in the required query row to add the query to your aliased finder. Click the icon again to remove the query from the aliased finder.
See Use the aliased finder to learn more.
Add or remove a query to or from your favorite queries
Select theicon in the required query row to add the query to your favorite queries. Click the icon again to remove the query from your favorite queries.
See Favorite queries to learn more.
Filter the query history list
There are different ways to filter the query history list:
- Select the icons at the top to show only blocked queries ( ), queries added to your aliased finder ( ) or favorite queries ( ).
- Click slider at the top to show only those queries accessed by you (User queries) or those accessed in the domain (Account queries).
- Use the time buttons at the top to filter the queries accessed within a specific time period up to that moment; from the last hour to the last year.
- You can also type in text in the search box and select Filter. The table will only display those queries containing the string you entered in their alias, table name or user who defined the query. Click Clear filter to show all the favorite queries again.
Add tags to the queries to easily filter them on the list.
Add tags → Hover over the desired query row, select the icon that appears at the end of it and select Add Tag. Alternatively, you can simply click under the Tags column. An extra row appears below for you to manage the tags for that query. Click the Add tag field, type in a keyword and click the + icon.
Filter by tag → The existing tags appear above the table, in the Tags section. Click one to activate it and filter the table accordingly. You can select several tags to display only those queries tagged with all of them. Alternatively, you can make the extra row appear and click one of the tags applied to that query to activate it as a filter for the whole table.
Tags created here are also shown in the tags section of the favorite queries for you to use them as filters.
You can combine different criteria to narrow the results of your filter. For example, you can filter those recent queries that are added to the aliased finder, have been accessed during the last hour, are tagged with "IP" and whose alias contains "data".
Open a query
You can open a query to check its data by clicking on the name. If you want to open the full query with all the operations performed, click on the name under the Alias column. If you want to open the original table click on the name under the Table Name column.
Copy a query to clipboard
You can copy a query to use it somewhere else. Hover over the name under the Alias column and click the button that appears to open a dialog showing the full query. Click the copy button on the right and a pop-up message will confirm it.