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.
10
votes
![](https://secure.gravatar.com/avatar/7578be785de49984b7b7b95a3a0f38ed?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
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.