Aeries Software

Ernest

← Aeries Ideas

My feedback

17 results found

  1. Save recent queries

    13 votes
    0 comments  ·  Aeries Ideas » Query (Aeries)  ·  Admin →
    How important is this to you?
    Ernest supported this idea  · 

  2. Create a report that contains GPA calculations per term

    18 votes
    1 comment  ·  Aeries Ideas » Transcripts  ·  Admin →
    How important is this to you?

  3. Aeries Query - Add Message if Results exceed the record return limitation

    7 votes
    0 comments  ·  Aeries Ideas » Query (Aeries)  ·  Admin →
    How important is this to you?
    Ernest supported this idea  · 

  4. Allow Private and Shared Queries

    5 votes
    0 comments  ·  Aeries Ideas » Query (Aeries)  ·  Admin →
    How important is this to you?
    Ernest supported this idea  · 

  5. Query - Allow Saved Queries to be shared or copied to other Schools

    72 votes
    3 comments  ·  Aeries Ideas » Query (Aeries)  ·  Admin →
    How important is this to you?
    Ernest supported this idea  · 

  6. Query Results Pop Up Window

    5 votes
    0 comments  ·  Aeries Ideas » Query (Aeries)  ·  Admin →
    How important is this to you?
    Ernest supported this idea  · 

  7. ENR Table in Query

    6 votes
    0 comments  ·  Aeries Ideas » Query (Aeries)  ·  Admin →
    How important is this to you?
    Ernest supported this idea  · 

  8. add .CSV as export option for Aeries Query

    6 votes
    1 comment  ·  Aeries Ideas » Query (Aeries)  ·  Admin →
    How important is this to you?
    Ernest supported this idea  · 

  9. Add SQL IN command to Query

    2 votes
    1 comment  ·  Aeries Ideas » Query (Aeries)  ·  Admin →
    How important is this to you?
    An error occurred while saving the comment
    Ernest commented  · 

    This would eliminate the need to have to build long strings of parenthetically grouped "OR" constraints.

    For example, if we were interested in STU records for 5 specific students (numbered 1 through 5, in this contrived example)...

    ...rather than:
    IF ( STU.ID = 1 OR STU.ID = 2 OR STU.ID = 3 OR STU.ID = 4 OR STU.ID = 5 )

    ...we could use something along the lines of:
    IF STU.ID IN (1, 2, 3, 4, 5)

    Ernest supported this idea  · 

  10. Query - Add Value Functions. (Quick example: Today)

    11 votes
    2 comments  ·  Aeries Ideas » Query (Aeries)  ·  Admin →
    How important is this to you?
    An error occurred while saving the comment
    Ernest commented  · 

    Add support for filtering an Aeries Query based on the current date/time, at runtime.

    For example, to list staff (STF) and their active job assignments (STJ), one might use a query similar to the following:

    LIST STJ ID SCL JC SD ED IF ( SD = NULL OR SD <= 'MM/DD/YYYY' ) AND ( ED = NULL OR ED >= 'MM/DD/YYYY' )

    While this works, it requires users to adjust the date each time they execute it.

    If support were added for a "current date" function, like the built-in T-SQL function "getdate()", this Aeries query might be rewritten as:

    LIST STJ ID SCL JC SD ED IF ( SD = NULL OR SD <= (( GETDATE() )) ) AND ( ED = NULL OR ED >= (( GETDATE() )) )

    NOTE: The above query does not work. It is provided as an example of how support for a current-date function might be implemented.

    Ernest supported this idea  · 

  11. Query - Show Saved Query Name and Allow Query to be Re-Saved with Same Name

    21 votes
    0 comments  ·  Aeries Ideas » Query (Aeries)  ·  Admin →
    How important is this to you?
    Ernest supported this idea  · 

  12. Can we make our Queries lists personal?

    8 votes
    0 comments  ·  Aeries Ideas » Query (Aeries)  ·  Admin →
    How important is this to you?
    Ernest supported this idea  · 

  13. Unable to Query Time

    6 votes
    1 comment  ·  Aeries Ideas » Query (Aeries)  ·  Admin →
    How important is this to you?
    Ernest supported this idea  · 

  14. Prevent Data Loss During USYSGCOD

    6 votes
    0 comments  ·  Aeries Ideas » Database  ·  Admin →
    How important is this to you?
    Ernest supported this idea  · 

  15. Query - Create custom column headers e.g. LIST STU STU.ID STU.U1 AS "IEP"

    20 votes
    0 comments  ·  Aeries Ideas » Query (Aeries)  ·  Admin →
    How important is this to you?
    Ernest supported this idea  · 

  16. Flex Scheduling - SMS Builder Teacher Selection

    9 votes
    0 comments  ·  Aeries Ideas » Flex Scheduling  ·  Admin →
    How important is this to you?
    Ernest supported this idea  · 

  17. Customizing Navigation Pages and Reports

    3 votes
    0 comments  ·  Aeries Ideas  ·  Admin →
    How important is this to you?
    Ernest supported this idea  · 

Feedback and Knowledge Base

(thinking…)
Solutions
Company
Get Help