Welcome back to the 2024-25 School Year! If you are a Parent and need information about the Aeries Parent Portal,
click here
. Otherwise, you can
dismiss this
.
Support
Sign in to Aeries Support
Enter your search term here...
Search
Back to all article categories
This category contains 4 folders
Aeries Query
Query FAQs
3
Sample Queries/Query Banks
Sample Query Bank - Flex Scheduling
How to Update Saved Queries for a User When They Transfer to a Different School
Query
15
Query Overview
Security for Query
Table Structure
Aeries Table Relations
Aeries Table Relations for Flex Scheduling
Database Definitions
Beginning Query
Intermediate Query
Advanced Query
Query Change
Query SKIP and KEEP Commands
Query Save or Load
Advanced Query - Elementary Examples
Advanced Query - Secondary Examples
Extended Student Fields for Query
Query Reports
5
Database Table Information Report
Query Report
Query Letter Report
Query Label Report
Query Envelope Report
How-To's and Troubleshooting
94
Aeries Query - Find Summer School Enrollment in Prior Year
Aeries Query - Why isn't the Extended Field SPECIALED Pulling all Students with an Active Special Education Record?
CALPADS Fall 2 Query To Find Potential Misassignments
Date Formats in Query
Ethnicity/Race in Query
Fall 2 Query CAR Records for Specific Teacher
Fall 2 Query CAR Records for Specific Teacher - Flex
How Can I Query The Course Attendance For An Alternative Ed School?
How Can To Get An Average Total GPA With The Grading Periods So Far This Year?
How to Create Unique Student Email Addresses in Query
How to determine if a Parent Portal account has the Weekly Progress Report enabled
How to Find CHANGE Queries in the LOG table Using Aeries Query
How to Find CHANGE Queries in the LOG table Using SQL Query
How To Find Student Tardies In Flex
How to Find Students That Are New This Year
How to Find Students That Were Imported From Online Enrollment
How to Find the Errors for a Specific Entity
How to Find User Account That Have Not Been Used For a Year
How to get Percentage of Special Ed Students
How to Identify At-Risk Students
How to Identify Contacts Who Live with the Student but are Tagged to Receive Mail
How to Identify Course Attendance for a Course
How to Identify Discipline Referrals Coded with SSSP
How to Identify Primary Contacts with Missing Cell Phone Numbers
How to Identify Sections with Less Than 5 Credits
How to Identify Students Coded as Victims of Harassment
How to Identify Students Exited with a Specific Exit Reason
How to Identify Students That Have Not Taken a Class
How to List Grade Without + or -
How to Print a List of Teachers and the Sections They are Teaching in a Flex School
