Home
Tutorial
Help Pages
Installation Guide
 
Tutorial Start
Register for a new system
Log in
Create a new User Group
Create a new User
Create a new Data Store
Browse for a Template
Use a Template
Modify Data Class
Delete a Data Class
Create a new Data Class
Add a single item
Add multiple items
Edit an item
Query for items (simple)
Query for items (advanced)
Save a query
Run a saved query
Edit a saved query
Delete a saved query
Save a Template
View Usage Log
Save Usage Report
Clear Usage Log
Modify Display Settings
Log Out
Browse as a Public User

Save a Query

Query for items (advanced) Run a saved query

You may find that some queries you need to perform frequently. It might be useful to save such queries so that you don't have to recreate them each time. Saved queries are displayed on the Data Store Home Page so that they can be easily run. Both simple and advanced queries can be saved. In this tutorial, you will save the advanced query you just created.

1. From the SQL Query Results page, select the save icon

2. In the Save SQL Query page, enter the values shown below:

Note that the Viewable By field specifies which User Groups can run the query and the Editable By field specifies which User Gorups can edit the query.

3. Select the Save button.

4. You will be redirected to the Data Store Home Page. Note that the query you just saved is added under the Data Views section.

Next you will run this saved query.

Query for items (advanced) Run a saved query