How to Save Query for Future Use
If you have created a useful query and want to reuse it in future, you can save it in the Query Gallery. For this, perform the following steps:
- Click Save on the Query page toolbar.
- Enter the name of the query in the Name box.
- Optionally specify a description for the query in the Description box.
Optionally clear the Save connection reference check box if you want to store query without binding it to a specific connection. In this case you will need to select a connection for it again after you open it from the Query Gallery.
When you save a query in the gallery, all the query settings are saved, including changes made in the query builder, SQL statement, etc.