In Dynamics AX 2012 (and 2009) we have the possibility to add Cue’s to the role center.
However, sometimes we would like to have Cue’s that reflect a dynamic time dimension. This is like: Orders today, Orders yesterday etc.
What we then can do is to use query values as today(), day(-1), LessThanDate(), RateRage() etc.
Like in the following example fetching sales order lines created today. Here I use the greaterThanDate(-1). Pay attention to the extra parentheses to make it work.
In AX 2012 you will find many such «dynamic» data query values, and you can find them in the class SysQueryRangeUtil.
Then here is the developers trick: Create your own methods to get the query range you need.
I have created my self some nice methods for getting a query rage for ThisWeek() and PrevWeek()
Or here is a way if you have a CreateDateTime field, like, and want all orders created today:
So now it is easy to create Role center cues with data like:
– Number of Sales order with value so far today/yesterday/this week/this month etc
Try it, and happy Daxing