I have a table of Events where each row has a time stamp (Start time) and I want to filter rows based on upcoming Events that start within the hour.
I've tried playing around with the ParameterSubscriptionFilter data field but can not get it to work.
In my head it would look something like this, where 306 is the PID of the Start time column:
FULLFILTER=306 > [LocalTime] AND [Subtract:306,[LocalTime]] < 01:00:00
How could I go about accomplishing something like this?
As far as i'm aware you can't filter indeed on timestamp, it is also not mentioned in the help:
Dynamic table filter syntax | DataMiner Docs
What should be possible tho is filtering on these types:
For numeric and string values: >, >=, <, <=, in_range, out_range
In addition, string values can use the wildcards * and ? if the == or != operator is used.
I'm wondering now if there can be some logic when tanslating the timestamp to a numeric value or string to implement something like that ...
Nonetheless, i do think it would be a good feature request to post here: