SysQueryRangeUtil methods as they are described here:

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/fin-ops/get-started/advanced-filtering-query-options do not cover the customer requirements. The customer wants to filter for example all orders to be release to warehouse for the next comming 3 hours. WIthin the standard filter options this is not there.


In my scenario I want to setup query and filters for different filters and batch job to be able to filter and select based on time windows

At this moment there is only the option to do this by days and not per hour or minutes.

Below the missing options within the current standard

  • (HourRange(-5,0))
  • (MinuteRange(-5,0))

This would be a great added value to have these options within the standard advanced filter oprtions.

Category: General