Query


The Aeries Query feature allows a user to use query statements to access data stored in Aeries tables. See Query.


The SKIP and KEEP commands in Query allow the user to create a temporary filter on records in the Student Data (STU) table that limits students according to certain criteria such as grade or gender. 


The SKIP and KEEP commands perform opposite functions. The SKIP command excludes certain students from the query results, where the KEEP command includes only certain students in the query results. In both cases, certain students are omitted.


 Multiple KEEP and SKIP query statements can be used together.  



Prerequisites

  • None


Steps



  Use the SKIP command to skip students

The SKIP command excludes certain students from query results. When in use, all subsequent query results will omit any students who meet the conditions specified in the SKIP query, such as students below a certain grade level.


When students are skipped, any subsequent records viewed or updated will NOT include the skipped students. 

  1. Under Commands, click SKIP to insert the SKIP command in the Query text box. Or, type SKIP in the Query text box.

  2. Complete the command by typing additional criteria in the Query text box. See Beginning Query and Query.

  3. Click Run.
    • The Query Results window opens. The skipped students are listed.
    • The "Student Records are being skipped" message is displayed at the top of the page as long as the SKIP command is in effect. This notifies you that any further actions taken will NOT apply to the skipped students.



  4. Close the Query Results window to return to the Query page.

    The SKIP command remains in effect until reset. See below.


back to top




  Use the KEEP command to keep students

The KEEP command limits query results to student who meet certain criteria. When in use, all subsequent query results will include only students who meet the conditions specified in the KEEP query, such as students of a certain gender.


When students are kept, any subsequent records viewed or updated will include only the kept students. 


  1. Under Commands, click KEEP to insert the KEEP command in the Query text box. Or, type KEEP in the Query text box.

  2. Complete the command by typing additional criteria in the Query text box. See Beginning Query and Query.

  3. Click Run.
    • The Query Results window opens. The kept students are listed.
    • The "Student Records are being skipped" message is displayed at the top of the page as long as the KEEP  command is in effect. This notifies you that any further actions taken will only apply to the kept students.

  4. Close the Query Results window to return to the Query page.

    The KEEP command remains in effect until reset. See below.



  Reset the SKIP or KEEP command


Resetting the command discontinues the skipping or keeping of students.


  1. When finished running queries or reports that utilize the SKIP or KEEP function, click Reset, which is located in the top-right corner.

  2. The  “Student Records Are Being Skipped” message is no longer displayed. Further queries or data will include all students.


back to top



  Undo the last SKIP or KEEP


When multiple KEEP or SKIP functions are used together, the last statement can be undone if needed.


  1. When one or more filters are in use, the KEEP/SKIP History section lists the filters currently applied in ascending order (oldest first).

  2. Click UNDO LAST KEEP/SKIP.

    The last item in the list is removed, and that filter is no longer applied. Only remaining filters are in effect.


back to top


Tables & Security

The Query feature is automatically enabled for Admins and Users. Users must also have access to the tables they are querying.

See Security for Query.


back to top