Microsoft Dynamics AX 2012 R3 Development-2 Locus IT Services

Microsoft Dynamics AX 2012 R3 Development-2

Locus IT ServicesMicrosoft Dynamics AX 2012 R3 Development-2

Lesson 4 – Queries

Queries

A query is an application object in the AOT. A query performs the same function as the select statements. It is a better option because it allows for more flexible user interaction when defining which records are to be retrieved. Queries provide more flexibility, especially when sorting and specifying ranges.

Queries enable you to ask questions about the data in the Microsoft Dynamics AX database and retrieve information. There are two ways to create queries:

  • Use the Queries node in the Application Object Tree (AOT) to create static queries using a graphical interface. For more information about creating queries in the AOT, see How to: Create Queries by using the AOT.
  • Use the query system classes to create dynamic queries in code. For more information about creating queries in code, see How to: Create Queries by Using X++.
Locus IT Project Management Office
What’s it?