Saved Queries
[Previous] [Main] [Next]

Saved Queries

When you click on teh SAVE button in the FIND screen, you will be asked to give a title for this saved query. The default title is the SQL Where clause that has been generated by your query. Ususally you can say it better.

sqlwhere_title4savedquery.png


The SELECT button both saves the value and runs the query. LEAVE AS IS just saves the value.

When you click on the SAVED tab you will see the following screen.

sqlwhere_savedqueries.png


This will have a list of queries that have been saved for this class, either by you or by someone else and marked for "ALL USERS".

You can click on the down arrow in the "Users who see" column and chose the "ALL USERS" option that appears if you think others would like to use this saved query.

You can click on the "Query Name" column and change the title.

If you click on the "Query" value this screen pops up.

sqlwhere_edit_query.png

If you know SQL you can manully modify your query here to make it do things that the simple query builder provided just can't do. When you click on the SAVE button your changes will be saved.

Now when you highlight this query and press the Execute Button your modified query will be used to filter the rows shown on the main table.