Session Description
earn basic procedures for creating and using Aeries Query statements in a request for data or information from your Aeries database. Basic Query will cover entering basic commands, the use of single table queries, selection of data fields, sorting data fields, and constructing simple conditions. This session is geared for the new Aeries user or Aeries users who have not worked with Query before.
Session Content
- Aeries Tables & Fields
- Accessing Query on the Aeries Web Navigation Tree
- Features of the Query Form
- Overview of Query Commands
- Creating a Basic Query from STU Table
- Query Results
- Query Reports
- Using Query Sort Command: BY
- Query Conditions: IF, AND vs. OR
- Including Inactive Students in Queries
- Saving & Loading Queries
- Creating additional Basic Query using single tables (i.e. TCH, CRS)
- Basic Troubleshooting of Query Errors
Related Documentation
Extended Student Fields for Query
Related Videos
Query Fields and Functions Video
https://acrobat.adobe.com/link/review?uri=urn:aaid:scds:US:04a5cf49-5cdf-3a81-95ce-f750a6563051