Using Discovery Panel in Aginity Pro

Revised June 16, 2021 17:29

Discovery Panel is a unique and very handy feature that allows you to identify and reuse previously executed or saved code quickly.

HOW TO USE DISCOVERY PANEL

To get started, go to the top corner of the sidebar on the right ⇨ Click on the Discovery tab, and you will see the Discovery Assistant menu.
By default, you can search both your query execution history (SQL) and Catalog simultaneously.
If you want to focus on just one option, select the panel's corresponding radio button.
When you've found the needed object, you can right-click on it to preview, open in tab, copy SQL, edit or delete from Catalog.

When you select the SQL history button, the search engine will automatically sort through all your query execution history and display all the available results.
If needed, type in any relevant text in a search field to narrow the results.
You can also filter the search results based on the database type or run date.
When you've found the needed object, you can right-click on it to preview, open in tab and use, or save to Catalog.

Searching Through DB Objects

Select the DB Objects radio button, choose the appropriate connection, and type of items you're looking for.
When the search engine displays the results, right-click on the selected object to get navigated to it directly in your Catalog.
If needed, type in any relevant text in a search field to narrow the results.

If you want to search in the Catalog only, click on the respective radio button. It will restrict your search, as shown below. Then, follow the pattern as with query execution history.
If you want to reference a catalog directly in a query, click on the () symbol at the top left corner next to the Catalog name.

Once you are done with a search, Aginity will dynamically update the results in the Discovery Panel to match the entered search terms.
By default, you'll see a small part of the query. If you need to see more, click on the two-arrows symbol ( ) that appears when you drag your cursor to the top right corner of the particular item. It'll expand the snippet further.