Aeries Ideas
33 results found
-
Aeries Query - Evaluate string fields with numeric contents as numeric
Aeries Query - Evaluate string fields with numeric contents as numeric such as GSS.MK
2 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 = *2 votes -
ENR Table in Query
When running a query on the ENR table it only pulls enrollment history from the database you are currently in, limiting all enrollment history pulled to information users already have. If the ENR table could be used to pull all enrollment history regardless of which database you are in it would give much more helpful and robust data!
2 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
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 -
Add PRIMARYROOM to the scheduling data extended fields
The most common request I've received in flex scheduling queries is about printing the room numbers along with the teacher info. At the moment users have to link STU SEC MST and include ( PRIMARYSECTIONNO = MST.SE ) in their queries.
It would really help query beginners to add an extended field for PRIMARYROOM that calls MST.RM.
1 vote -
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.
1 vote -
Query Clean up purge old queries/not used
It would be helpful to be able to easily identify queries that pull data from old/unused field and tables and remove or hide them.
1 vote -
Query - Create custom column headers e.g. LIST STU STU.ID STU.U1 AS "IEP"
For reports with duplicate or non-meaningful column headers add an 'as' verb to the query to for the column header:
LIST STU STU.ID STU.U1 as "IEP" would yield:
Student ID | IEP | ...
112345 | IEP | ..
also for description fields instead of DC_ xyz
LIST STU STU.ID STU.PED? AS "Parental Education" STU.GR, ...
1 vote -
Query Results Pop Up Window
Query - Provide a message if query is incorrectly formatted instead of just displaying a gray pop up window.
1 vote -
Student Preferred Name in Query
Add the ability to use a student's preferred name (alias) in lieu of legal name on a query when querying LIST STU ID FN LN etc...
Also please add the ability (at the school/district level) to use the FNA in place of the FN for the API, OneRoster, Clever, and other methods of integration with third party systems.This is especially important for students who may have a dead-name we need to keep in the SIS for State Data reporting but do not need to use for on campus / day-to-day purposes.
For queries, I'm thinking this could be a…
1 vote -
Enhance query export to Excel to support hidden Hexi-decimal characters.
Enhance query export to Excel to support hidden Hexi-decimal characters. Workaround: Use Excel Old
1 vote
- Don't see your idea?
