Aeries Ideas
43 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.
73 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.
46 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.
28 votes -
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, ...
21 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.
21 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
14 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.
13 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.
11 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).
8 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.
8 votes -
8 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.8 votes -
add .CSV as export option for Aeries Query
I'm seeing if it would be possible to add .CSV as an export option for Aeries Queries.
7 votesWe are researching what it would take to implement this request, but we know the scope and size of the project before we can put it into our development roadmap
-
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.
7 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.
7 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.
7 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.
7 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!
6 votes -
Query Results Pop Up Window
Query - Provide a message if query is incorrectly formatted instead of just displaying a gray pop up window.
6 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
6 votes
- Don't see your idea?