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 ...
Fri, Mar 2, 2018 at 6:50 PM
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...
Sat, Mar 3, 2018 at 8:24 PM
Database Table Information Report
The Database Table Information Report can be printed using the Database Table Information option under Other on the Reports menu. This report can pri...
Thu, Sep 27, 2018 at 9:24 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...
Thu, Sep 27, 2018 at 9:22 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 on...
Thu, Sep 27, 2018 at 9:21 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
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
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
Query Report
Creating a Report After running a query statement a formal report can be generated by clicking on the REPORT button. The following box will disp...
Sat, Feb 10, 2018 at 2:16 AM
Query Letters
The LETTERS button is used to merge data into a formatted letter. The letters are first created in the Query Letter Text Editor. A query statement is then u...
Sat, Feb 10, 2018 at 2:19 AM
Query Labels
After running a query statement, the LABELS button can be selected to create different types of labels, such as mailing labels, student folder labels, etc. ...
Sat, Feb 10, 2018 at 2:05 AM
Query Envelopes
When creating envelopes the query generated is the same as creating an address label.  Envelopes containing more than one line must utilize the ‘\’ in the...
Fri, Feb 9, 2018 at 3:20 PM