Thursday, February 18, 2010

SysQueryRangeUtil class

The SysQueryRangeUtil class is just the great enhancement to the AOT queries made in AX 2009. It is possible now to specify a range on the AOT query with the value taken from a method's return. The requirements for such range method are quite simple: the method should be static, return string, be a member of the SysQueryRangeUtil class and not be related on the data fetched by the query.

There are quite a lot of useful methods on the SysQueryRangeUtil class available out of the box, like currentEmployeeId() - returns current employee ID, dayRange() - allows to specify date interval around current date, etc. And it is possible to add a new custom method to this class as well.

6 comments:

  1. Hello :) Thank you a lot for sharing such interesting and educative information. I've just searching something connected with the topic of SysQueryRangeUtil class in Microsoft Dynamics AX.

    ReplyDelete
  2. This post has gotten pretty old admin.. consider updating this post for newer version of dynamic 365.

    ReplyDelete