Aeries Ideas
45 results found
-
Enhance query export to Excel to support hidden Hexadecimal characters.
Enhance query export to Excel to support hidden Hexadecimal characters. Workaround: Use Excel Old
6 votes -
Unable to Query Time
Aeries Query can recognize dates BUT it cannot query Time. (ie if you want to query out a time range (9:30 Am thru 12:30 PM), you cannot use IF ST >= "9:30 AM" AND ST <= "12:30 PM"). Any time manipulation needs to happen in Excel. Please make a way to query out time!
6 votes -
Query
Query - Add ability to join GBO and GBK in Aeries query
5 votes -
Income Survey/FRE record/Parent email
Please include the Income Survey on the ICL table. Our auditors want to have a date and time stamp and electronic signature in our audit for the Income Survey and the IP address.
The Data Confirmation Report gives the date/time but not who filled it out. It is not complete for our needs.
Another request, please include the email address of the person completing the record on the FRE record.
5 votes -
Query results for the HSG table
Query Results - When running a query on the Graduation Status (HSG) table, the TOTAL shows before the Z Subject Area Code. Could the sort be fixed so that TOTAL comes after Z or the last Subject Area Code?
5 votes -
Query Envelope - Print return address on envelopes
Add option to print return address on envelopes for districts or schools which do not have printed envelopes
5 votes -
Allow Private and Shared Queries
Add the ability to save queries for yourself without having to share them. This way, someone doesn't have to have a txt document.
5 votes -
Query - Ability for Descriptions on STU.RS and STU.ITD Fields
The RS and ITD do not garner a description when running a query. Would like the ability to do so. So that we may be able to see the school's name as opposed to the numerical information the query gives out.
5 votes -
Aeries Query - Evaluate string fields with numeric contents as numeric
Aeries Query - Evaluate string fields with numeric contents as numeric such as GSS.MK
4 votes -
Add SQL IN command to Query
Add the IN command from SQL to the Aeries web Query
3 votes -
Query ADA by Subgroups
Be able to query ADA by subgroups such as foster/homeless, socio-economic, Hispanic, EL, etc. Currently, the information on the ADA report are calculations occurring to add up the total ADA values, and is not something we can query. The information from the Monthly Attendance Summary is not queryable, as it is calculations performed only for the report, and is not stored in any table
3 votes -
Query - Ability for Descriptions on STU.CNS
Description on STU.CNS would give users without STF permissions the ability to query by teacher/counselor. Flex uses STF.ID for primary teacher and makes it very difficult when they just get an ID number from STU.CNS. We don't want to give out STF permissions to all these people that have access to STU.
3 votes -
Flex - Attendance History Detail - Allow the AHD table to be queried for period absences
In a flex environment the following query no longer works. Please create a way for the AHD table to be queried for Period Absences.
Translate for Flex schools with Period Attendance:
LIST STU STU.ID STU.FN STU.LN STU.GR AHD AHD.SCL AHD.YR AHD.DE AHD.AL AHD.P1 AHD.P2 AHD.P3 AHD.P4 AHD.P5 AHD.P6 AHD.P7 STU.AD STU.PG IF AHD.YR = 2022-2023 AND AHD.CD = *3 votes -
Querying Total Instructional Minutes
I wish the field for Total Instruction Minutes and Total Minutes in the Bell Schedule Table was a field you could query. The start time and the end time is a field you could query but not the total time
3 votes -
Query - Support Questions or Substitutions
Please add support for questions or substitutions. Allow a query to be created that prompts the user for a value that can be placed within the query. A simple example would be a LIST STU ID NM GR IF GR = @GradeLevel. When the query was run, the user would be prompted to enter the value of @GradeLevel.
3 votes -
Ability to query ISG.IUT and ISG.UUT in Aeries web.
Currently the IUT and UUT fields in the ISG table can only be queried in SQL. Please make this available in Aeries Web Query.
2 votes -
Aeries web query - Allow to show results of ELPAC test to appear horizontally for each student.
Aeries web query - Allow results of ELPAC test to appear horizontally for each student instead of appearing vertically several times.
2 votes -
Analytics Query Extended Field - Add Period Absences
Add period absences in the Analytics LCAP dashboard so they can show in the Student Extended fields query.
Right now, it has all day absences, but not period.
2 votes -
Query Change to MST/SMS Days of the Week Fields
Query Change to the MST/SMS DY field needs to update the MST/SMS days of the week fields (MM, MT, MW, MR and MF). The MST.DY and individual days of the week fields need to stay in sync.
2 votes -
Integrate GPT-Powered Query Generation into Aeries Next Gen
As part of the Aeries Next Gen platform, it would be extremely valuable to integrate GPT (Generative Pretrained Transformer) technology for districts using the hosted Aeries solution — specifically for generating and refining Aeries Queries.
Currently, many users find the Aeries query process cumbersome, resulting in frequent inaccuracies or empty results. By leveraging LEA-specific GPT models or machine learning, Aeries could introduce a natural language interface that allows users to ask open-text questions which are then converted into accurate Aeries queries.
Example Prompt:
“List all 7th grade students by school, student name, ID, and only include students with a grade…
1 vote
- Don't see your idea?
