Use, copy, edit, and delete saved queries

Queries help you search for and filter a group of records that matches specific criteria at a particular time. Your Aspen system administrator has most likely created a number of queries for your district.

Note: Do not select All Records from your Filter menu if your next step will be to run a query. Instead, select All Records in the Search based on list on the Query window. Not only does this save a page refresh, it also prevents a potentially large list of records from being loaded unnecessarily.

To use, copy, edit, or delete a saved queryClosed a request to find a group of records that match specific criteria at a particular time:

  1. Go to a list page, such as the Student List.
  2. On the Options menu, click Query. The New Query pop-up appears:

  1. Click Select. The Query Pick List appears:

  1. Select the query you want to use.
  2. Do one of the following:
    • Click Use to run the query, then click Search.
    • Click Copy to use the saved query as a shell to create a new one. Change the query name, owner type, and owner name as needed. Click Save.
    • Click Edit to change the query name, owner type, and owner name. Then click Save. The edits made apply to all users who have access to this query.

      • Note: You might not have security privileges to copy queries to other users in your school or district, or for your entire school or district. See your Aspen administrator for more information.
    • Click Delete to remove the query. The query will be deleted from the Filter menu Filter icon. of all users who have access to it.
  3. If you are using a saved Advanced or Direct SQL query and Prompt for value had been selected, the 'Search criteria' pop-up appears.
  1. Enter the search criteria, and click Submit. The list page displays the records that meet your search criteria.