Session Description

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

Query Overview

Table Structure

Beginning Query

Tables and Fields Icon

Query Save or Load

Query Report

Extended Student Fields for Query

Additional PDF documentation for this session is attached at the bottom of this article.


Related Videos

Query Overview Video

Query Fields and Functions Video

Query Sorting Video

Query Multiple Sorting Video

Query Simple Conditions Video