Extending Microsoft Dynamics 365 for Operations Cookbook

There's more...

A good tile is a tile that takes you to service orders due tomorrow, so we will need to filter based on a function.

In the query range's Value property, we can also enter query functions. The standard functions are defined in the SysQueryRangeUtil class. So, to filter on today's orders, you will enter (currentDate()) in the query range's Value property.

We used to modify this class to add new functions in Dynamics AX 2012, but since overlayering is discouraged, we have a better way to do this in Operations.

Create a new class and call it ConWHSQueryRangeUtil. The name is not important. To create a method that returns a date a number of days from today, use the following code:

[QueryRangeFunction] public static date RelativeDate(int ...