If you are new to Aeries and would like to understand queries or it you would like a refresher these videos will add value to the time spent watching and the productivity when returning to your task.
Query Fields and Functions Overview (12:49)
- Query Overview
- Layout of Query Screen (0:48)
- How Queries Are Built (1:31)
- Printing a Query (8:25)
- Modifying an Existing Query (9:58)
- Spend a Query to a Spreadsheet (11:14)
- Query Fields and Functions
- Overview of Fields and Function (0:01)
- Review of fields (18:58)
Query Fields and Functions Length (20:30)
Query Sorting Length (13:30)
- Help line (1:05)
- Simple Sort by fields (1:10)
- Sort with group by fields (3:15) ex: list students with all 2nd graders, then all 3rd graders
- Run report (4:15)
- Run report with page break by groups fields (5:22)
- Run report with title and header (8:15)
- Run report by field in descending (reverse) sort order (9:15)
- Diff between CS and web versions of Aeries sorts (12:32)
Query Multiple Sorting Length (13:07)
- Sorting by with multiple fields (0:21)
- Sorting with 2 groupings (1:58) ex: sort by all 2nd grade females, then 2nd grade males, then 3rd, etc
- Change order of sorting/grouping (5:40)
- Sort groups by descending (reverse) sort order (6:48)
- Sort within multiple groups by descending (reverse) sort order (8:36)
- Run report (11:51)
Query Simple Conditions Length(13:34)
- Purpose (0:19)
- Sequence (1:15)
- Components (2:00)
- Component Constant (3:39)
- Comparison (4:25)
- Does not equal (6:25)
- Contains (8:00)
- Does not contain (9:10)
- Help Line query reminder (11:12)
Query Multiple Conditions (7:26)
- Purpose (0:20)
- Linking (0:40)
- Setting up Query and Adding conditions (0:55)
- Adding a second condition (1:45)
- “AND” Inclusive Condition (2:20)
- “OR” Exclusive Condition (3:07)
- Error (3:25)
- Inclusive vs. Exclusive (4:47)
- Complete Conditions (5:43)
Query Complex Conditions (8:39)
- Query Complex Conditions (AKA If/And/Or Statements)
- If statements
- And statements
- Or statements (1:03)
- Parentheses (4:46)
- Keep statement (6:40)
- Keep/Skip history (8: 01)
