Share via


Query Reuse in Multiple AOT Objects

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

The following Application Object Tree (AOT) object types can have a query as their data source:

  • Data Sets

  • Forms

  • Reports

  • Views

Under the Data Sources node of a Form, you can build a complex query that consists of multiple data sources. You can repeat this process for a Report and a View.

However, it is easier to build the business object structure one time by using the query framework, and then reuse the query. You can reuse the query as the data source for a form, report, and view.

Query Changes are Instantly in Effect for Consuming Objects

A change to a query instantly goes into effect for all the forms, reports, and other AOT objects that use the query as their data source. This design avoids the labor and risk involved when the same table join must be modified repeatedly under the Data Sources node in several AOT objects.

Query Cannot be Combined with Other Data Sources

When an AOT object has a query as its data source, no other item can be an additional data source. Therefore no table, view, or any other query can be added to a Data Sources node that already has a query.

See also

Query Framework in the AOT

Announcements: New book: "Inside Microsoft Dynamics AX 2012 R3" now available. Get your copy at the MS Press Store.