Page History

...

1. Select Manage stored queries from the Tools menu.
   Image Removed Image Added
   Image RemovedImage Added
2. When a repository or query is selected in the Stored queries pane the following options are available:

   Icon	Description
   	The Add query button creates a new query in the repository.
   	The Rename query button shows a dialog to let you rename the selected query. This button is only enabled if a query is selected.
   	The Copy query button shows a dialog allowing you to copy the query to a selected repository. If the query has tags they will be added to the copy if they exist in the target repository. If they don't exist they will be created and added if Create tags that don't exist is checked, otherwise they won't be added. This button is only enabled if a query is selected.
   	The Remove query button removes the selected query from the repository. This button is only enabled if a query is selected.
   	The Add query from SQL script button creates a new query in the repository and shows a dialog for you to pick a SQL script file to load it's contents from.
   	The Save as SQL script button shows a dialog to let you save the selected query to an SQL script file. This button is only enabled if a query is selected.

3. To make changes to a query select it in the Stored queries pane. The query and its tags will be shown in the middle pane.
   Image RemovedImage Added
• • To add a tag, click the button . The button will be replaced with a text field and a list showing the available tags that haven't been added to the query.
    • Entering some characters into the text field will filter the list to show only tags that start with those characters. You can use the up and down arrow keys to highlight a tag and press enter to accept it and add it to the query.
    • Pressing enter Enter when no tag is selected in the list, and the text in the field is not the same as existing tag, will create a new tag with the text in the field and add it to the query.
  • Double clicking a tag in the Available tags list will add it to the query.
  • To remove a tag, click the button on the tag.
4. When a repository or query is selected all tags in that repository will be shown in the Available tags pane with the number of queries using each tag shown in parentheses. The following options are available:

   Icon	Description
   	The New tag button creates a new tag in the repository.
   	The Edit tag button shows a dialog to let you rename the selected tag. This button is only enabled if a tag is selected.
   	The Delete tag button deletes the selected tag from the repository. This button is only enabled if a tag is selected.