Ax 2012 Queries

Queries in AX2012

There are three types of queries in Dynamics Ax.

1.       INLINE QUERIES

2.       AOT QUERIES

3.       QUERY BUILD API

Each of them has their different usage and conditions in which they are suitable to use.

Usage of Inline Queries:

·         They are used when we require a query that isn’t reusable or is used for a specific condition or scenario.

Usage of AOT Queries:

·         They are used when we require a query that has to be reused on multiple scenarios.

     Usage Of Query Build API:

·         Mostly Used when we have to run existing AOT Queries with modification.

   

     EXAMPLE:     

                 In this Example I will Show simple jobs demonstrating a Single Query in all three Forms.

         

     Inline Query:

                           

The Image above shows a Simple Query in which there is a join between HcmBenefit & HcmBenefitPlan Tables.

     AOT Queries:

              We need to create a new Query under the Query node of the AOT.

                                      

                  

    Then to run this query we need to create a simple job as follows.

                

                                       

  Query Build API:

   Now to produce the same query with Query Build API we have to create a Job as shown below.