29 results found
Query - Allow Saved Queries to be shared or copied to other Schools
It would be great if you could save a query to more than one school or if the system allowed you to copy a query to one or more schools to save time. This would allow the same queries to be created at the District level and shared to school sites.59 votes
Please add Custom Labels to Query
I would like to create customized Query labels in Aeries Web. They are only available in Aeries Client.40 votes
Query Sort Tables and Fields Option
Please make the options on the Query table possible to sort. This would make easier to find the field that is needed.19 votes
Query - Show Saved Query Name and Allow Query to be Re-Saved with Same Name
When a saved query is opened, show the query name on the screen. If changes are made to the query allow the query to be saved using the same name instead of creating a new name.16 votes
Query - Add Value Functions. (Quick example: Today)
Add value functions where the value would be retrieved at run time. A simple example would be LIST STU ID NM ED LD IF ED <= @@Today AND ( LD = NULL OR LD >= @@Today ) This would make queries a much more viable option for disseminating information in a school district with too many people to train on the intricacies of Query.10 votes
Save recent queries
It'd be awesome if we have access to our last 5-10 queries that we used. Sometimes the Aeries page times out before I have a chance to save a query and if I'm bouncing back and forth between two queries, it'd be really convenient to just have it there to click on.9 votes
Query - Grade Descriptions (GR?) do not display for grades below 0
Query - STU Grade level descriptions do not display in Query for students in Kinder, TK and PS when using "GR?" in the query.
Query needs to be adjusted to look at COD.AC = STU.GR in the Get_Description function.6 votes
Query Letter Text Editor - Add ability for letter translations
In Query Letter Text Editor we are hoping that you could set up the letter like Attendance or Suspension letters, where you can add the translation letter to the English letter so that when they print a letter to all students in the school, they can have all of them in alphabetical order, regardless of whether they are English or Spanish. As of now, they have to run the English letter they created, then run the Spanish letter. Two separate letters.
In addition allow other languages and their writing systems to be used like Punjabi.6 votes
Aeries Query - Add Message if Results exceed the record return limitation
The Aeries query has a record return limitation of 100000. It would be nice if the end user gets a warning message if their query result exceeds the record limitation. This will make the user aware that not all the records are showing up in the outcome of the query.6 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
Allow a Keep option for reports and on rosters
Include a KEEP query button for reports so we have the option to KEEP students that were on the report. This would be helpful for any report for a teacher roster, gradebook, or where there are certain conditions of selecting the students on the report (ex. Repeated courses).4 votes
Can we make our Queries lists personal?
Right now if anyone on my campus creates a query it shows up on my list. Queries created by the nurse are of no use to me and vice versa. Having her queries on my list takes up space and makes the process of finding my queries longer.
Another way of doing this could be to add additional filtering options to filter for the current user, or favorite queries.4 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?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!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
Query - Add ability to join GBO and GBK in Aeries query2 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
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.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 time2 votes
- Don't see your idea?