Add a GETDATE() Function
It might be useful to drop old events.


You can use late arrival policy (using the Drop option) to filter out old events.
5 comments
-
Min He commented
Functions like GetDate() or RAND() is not repeatable, which means you may not get same result from achieved events.
Is repeatability critical to your scenario or it is something you do not need?
-
Paul commented
I second the value of a "today" function. I was looking to do a very simple comparison (i wanted to query something like "give me all the events for today"...so i made my window 1 day, and was going to compare the timestamp to todays date...)
-
Todd Chittenden commented
Knowing the value of "TODAY", in any given programming language is just basic stuff.
How could I otherwise look up history for events that happened two months ago, or RETAIN HISTORY but only FILTER my Power BI report based on the AGE of the events if I did not know when TODAY is.It's as ubiquitous as the IF/THEN/ELSE or CASE constructs.
-
Srđan Božović commented
This would be usefull for answering questions like:
How many times the alarm turned on today?Late Arrival Policy would not address this
-
Currently, you can drop old events by using the Late Arrival Policy on the job's Configure tab. Does that address your use case? If not, please elaborate.