This folder contains 16 articles

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...

Thu, Mar 30, 2023 at 2:31 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

Aeries Table Relations for Flex Scheduling
When creating a query for Flex Scheduling, use the following diagrams to assist with the table relations structure.  Attachments below are available for dow...

Tue, Nov 9, 2021 at 8:07 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 new Table/Field Info icon next to the Help icon in the corner of each page. This new icon will present an overlay of the table designation...

Thu, Apr 15, 2021 at 4:34 PM

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...

Tue, Jun 16, 2020 at 11:56 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...

Tue, Sep 29, 2020 at 1:08 PM