Query

These articles explain how to use the Query to create customized lists and reports of data.

Query Overview
All data entered into Aeries is stored within tables in the database. The Query option enables you to access the data stored in these tables. The process ge...
Sat, Feb 10, 2018 at 12:45 AM
Security for Query
Admin and User user types will automatically have the Query node in their navigation tree and basic Query functionality without any additional security setu...
Fri, Feb 23, 2018 at 5:00 PM
Table Structure
What is a Table?   A table is a file that stores certain data entered into the Student Information System.  The Query form below displays some of the tabl...
Sat, Feb 10, 2018 at 12:52 AM
Aeries Table Relations
Aeries related tables are joined through common fields and some tables are joined to a number of different tables.  On the left side the TN field in TCH lin...
Sat, Feb 10, 2018 at 12:53 AM
Database Definitions
The Database Definition page allows the user to select a table from a dropdown list of tables and receive a sortable list of table fields and related table ...
Wed, Jan 9, 2019 at 11:26 AM
Tables and Fields Icon
There is now a Table/Field Info icon next to the Help icon in the corner of each page.  The icon will link to an appropriate Knowledge Base arti...
Wed, Jan 9, 2019 at 9:59 AM
Beginning Query
The following documentation provides information on some of the general functions available to you through Query. To begin the query process, click on the Q...
Wed, Jan 9, 2019 at 11:07 AM
Intermediate Query
Query Statements - Using One Table A Query Statement can be created with one or more tables.  The following query statement utilizes one table, which only ...
Thu, Jan 10, 2019 at 11:56 AM
Advanced Query
Review of Query Commands A Query Command is the first step used when generating a query.   The structure is a definite order that the query must be ente...
Sat, Feb 10, 2018 at 1:21 AM
Query Change
Change Button versus CHANGE Command Aeries Query provides two methods to quickly change data in a table, the Change button and the Change command. The idea...
Fri, Feb 23, 2018 at 2:57 PM
Query SKIP or KEEP
The SKIP and KEEP commands are used to create temporary filters on the STU table that will only contain students meeting certain criteria such as a particul...
Sat, Feb 10, 2018 at 1:59 AM
Query Save or Load
Save Query Statements Once a query statement has been created and generated it can be saved and accessed for later use.  It is suggested that only queri...
Sat, Feb 10, 2018 at 12:43 AM
Advanced Query - Elementary Examples
Selecting Records by Criteria Criteria to select only certain records for the query results is added to the end of the query statement. The IF command a...
Sat, Feb 10, 2018 at 2:12 AM
Advanced Query - Secondary Examples
Selecting Records by Criteria Criteria to select only certain records for the query results is added to the end of the query statement. The IF command a...
Sat, Feb 10, 2018 at 1:23 AM