Search Panel is a unique and very handy feature that allows you to quickly search for previously executed or saved code for reuse.
How to use Search Panel
1. Open the Search sidebar by clicking the the search mark icon in the top right corner of the application.
2. Click the filter icon to select which item(s) you to search.
You can choose between:
- All
- Your SQL query execution history
- Catalog Assets
- Database Objects
3. When you've found the needed object, you can right-click on it to preview, open in tab, copy SQL, or reveal in Catalog (for Catalog assets).
Searching Query Execution History
The SQL history filter allows you to search through your entire query execution history and display all the available results.
If needed, type in any relevant text in a search field to narrow the results.
When you've found the needed object, you can right-click on it to preview, open in tab and use, copy SQL, or save to Catalog.
Searching Through Database Objects
Select the DB Objects 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 navigate to it directly within the Catalog panel.
If needed, type in any relevant text in a search field to narrow the results.
🔎 NOTE: If 'Navigate to' is disabled, object could be hide with using feature - Database filtering.
Searching Coginiti Catalog
If you want to search in the Catalog only, click on the respective button. It will restrict your search, as shown below. Then, follow the pattern as with query execution history.
Expanding the Results
Once you are done with a search, Coginiti will dynamically update the results in the Search Panel to match the entered search terms.
By default, you'll see a small section 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 code further.