This folder contains 15 articles
Query
These articles explain how to use the Query to create customized lists and reports of data.
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
Admin and User user types will automatically have the Query node in their navigation tree and basic Query functionality without any additional security setu...
Wed, May 1, 2024 at 6:19 AM
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 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
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
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
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, May 16, 2024 at 2:44 PM
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, May 16, 2024 at 2:45 PM
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
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