Wednesday, 2 November 2022

Dynamic query ranges to run queries in Microsoft Dynamics AX

 Use the standard flexibility of the queries


The standard queries already support a level of flexibility with predefined functions. You can read more about that in this blog post: 

http://daxmusings.codecrib.com/2013/07/custom-query-range-functions-using.html


The class “SysQueryRangeUtil” contains several predefined methods which can be used to make your query more dynamic. The format is plain and simple: ( some code ), you only need the parentheses around the method.


Just to explain how this can be used, here are some samples:




Many other scenarios are possible. This second option gives you the ultimate flexibility to create dynamic queries.

No comments:

Secure API Integration in D365FO Using OAuth2 and Azure Key Vault (X++)

  Secure API Integration in D365FO Using OAuth2 and Azure Key Vault (X++) Integrating with external APIs securely is a common requirement in...