Aeries Ideas
40 results found
-
New UI: Notification that Students are being skipped needs to be enhanced & stay visible
In the new Aeries Interface after running a Keep/Skip in query, the notice to remind people that Student Records are being skipped does not stand out like it should. It should be in a BRIGHT impossible to miss color. Also, the notice needs to be located in the header so it is visible on any page that the user navigates to.
5 votes -
Query labels and page break
On query reports we have the ability to page break on the sorted field. We would like to be able to page break on printing query labels on that same sorted field
12 votes -
Add Table/Field Overlay to All Pages
Please put the waffle on every page so that we know the query tags rather than sending us to other documentation
1 vote -
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
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, ...
18 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.
1 vote -
Export to Google Sheets
Being a Google heavy district we work with Google Sheets primarily for most data tasks. The query export process for us could use some love. We either need to copy and paste each page of 500 results over, or bounce out to an excel sheet for the sole purpose of copying and pasting into Google sheets for collaboration.
If there was a conduit to query out to the clipboard or directly into a new google sheet, it would cut out several steps for tasks that we do quite often.
3 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
3 votes -
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.
5 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.
2 votes -
Query Report won't page break when using any Extended Field in Query
When including any Extended Field in a query and attempting to use the Page Break option from the Report button, the page break will not work.
Example: PRIMARYTEACHERNAME19 votes -
Query
Query - Add ability to join GBO and GBK in Aeries query
3 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 -
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!
5 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 -
Query Results Pop Up Window
Query - Provide a message if query is incorrectly formatted instead of just displaying a gray pop up window.
3 votes -
Enhance query export to Excel to support hidden Hexadecimal characters.
Enhance query export to Excel to support hidden Hexadecimal characters. Workaround: Use Excel Old
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.
4 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 -
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
- Don't see your idea?