Skip to content

Aeries Software

Ernest

← Aeries Ideas

My feedback

8 results found

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

    11 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    2 comments  ·  Aeries Ideas » Query (Aeries)  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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  · 

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

    19 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Aeries Ideas » Query (Aeries)  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    Ernest supported this idea  · 

  3. Can we make our Queries lists personal?

    8 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Aeries Ideas » Query (Aeries)  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    Ernest supported this idea  · 

  4. Unable to Query Time

    6 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  Aeries Ideas » Query (Aeries)  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    Ernest supported this idea  · 

  5. Prevent Data Loss During USYSGCOD

    5 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Aeries Ideas » Database  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    Ernest supported this idea  · 

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

    20 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Aeries Ideas » Query (Aeries)  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    Ernest supported this idea  · 

  7. Flex Scheduling - SMS Builder Teacher Selection

    9 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Aeries Ideas » Flex Scheduling  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    Ernest supported this idea  · 

  8. Customizing Navigation Pages and Reports

    3 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Aeries Ideas  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    Ernest supported this idea  · 

Feedback and Knowledge Base

(thinking…)
Solutions
Company
Get Help