You’re offline. This is a read only version of the page.
I want to use the advanced filter functionality to set up a batch process that selects all kanbans with an Emptied date/time stamp that was more than 10 minutes ago (I want to give people time to edit the quantity before the batch selects it). I know how to use (DayRange()) to do this with full days, but is there a way to do the same type of filter criteria based on the time part of the date/time field?
Also, is there any good syntax reference anywhere to the list of functions (like DayRange) and other syntax (like SQL statements) that can be used in advanced filters?
Thanks in advance
*This post is locked for comments
I have the same question (0)
Hi Garys,
The DayRange() and other syntax can be found in the class SysQueryRangeUtil. The one you are looking for is not available. The syntax greaterThanUtcDate() and lessThanUtcDate() are close to your needs, but also calculates with days. You can create new methods in this class. These are then also available in the advanced filters. Within the new method you can calculate with e.g. minutes in stead of days.
You need to have development skills to achieve it.
Share
Report
All responses (
Answers (
300,894
