Page History
To manage stored queries...:
- Select Manage stored queries from the Tools menu.
...
-
- When a repository or query is selected in the the Stored queries pane the following options are available:
REPLACE WITH THIS IMAGE: Images/Common_Icons/addqueryicon.pngIcon
Description
REPLACE WITH THIS IMAGE: Images/Common_Icons/renamequeryicon.pngThe Add query button creates a new query in the repository.
REPLACE WITH THIS IMAGE: Images/Common_Icons/copyqueryicon.pngThe Rename query button shows a dialog to let you rename the selected query. This button is only enabled if a query is selected.
REPLACE WITH THIS IMAGE: Images/Common_Icons/removequeryicon.pngThe 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.
REPLACE WITH THIS IMAGE: Images/Common_Icons/open_sql.pngThe Remove query button removes the selected query from the repository. This button is only enabled if a query is selected.
REPLACE WITH THIS IMAGE: Images/Common_Icons/saveicon.pngThe 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.
- 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.
...
- 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 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.
- . The button will be replaced with a text field and a list showing the available tags that haven't been added to the query.
- 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:
REPLACE WITH THIS IMAGE: Images/Common_Icons/addqueryicon.pngIcon
Description
REPLACE WITH THIS IMAGE: Images/Common_Icons/renamequeryicon.pngThe New tag button creates a new tag in the repository.
REPLACE WITH THIS IMAGE: Images/Common_Icons/removequeryicon.pngThe 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.