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.
Robert Burks
shared this idea
-
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.
-
Adam VeVea
commented
Add a special field that specifies the current system date, so when doing date comparisons in queries you can filter by system date when looking at student enter dates, etc.
