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:

  1. Click Save on the Query page toolbar.
  2. Enter the name of the query in the Name box.
  3. Optionally specify a description for the query in the Description box.
  4. 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.

    Save Query window

When you save a query in the gallery, all the query settings are saved, including changes made in the query builder, SQL statement, etc.

You can open or delete a saved query later in the Query Gallery.