Skip to content

Aeries Ideas

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback

35 results found

  1. 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

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. 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.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  5. 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.

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. 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, ...

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. Query

    Query - Add ability to join GBO and GBK in Aeries query

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. 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!

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  11. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. Enhance query export to Excel to support hidden Hexadecimal characters.

    Enhance query export to Excel to support hidden Hexadecimal characters. Workaround: Use Excel Old

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  13. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  14. 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!

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  17. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  18. 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.

    64 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  19. 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.

    18 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  20. 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.

    11 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
← Previous 1
  • Don't see your idea?

Feedback and Knowledge Base