Query Framework for Business Objects

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

In the Application Object Tree (AOT), the query object can be designed as a modular business object. The following AOT object types could have their Data Sources node be based on a query object:

• Data Sets

• Forms

• Reports

• Views

Object Reuse

A query that is developed as a business object (such as for sales order) can be used to build AOT objects, such as a report. The benefits of object reuse include the following:

• There is less AOT work for you in building data sources.

• You have to make data source changes in only one query. This causes fewer errors than when you must modify several objects the same way.

• The changes that you make to the one query are instantly in effect for all objects based on that query.

Ways to Reuse a Query

Three ways a query can be reused include:

• Query Reuse in Multiple AOT Objects

• Query Reuse by Independent Duplication

• Query Reuse in Multiple AOT Objects

For more information about how to design by using a composite query, see Walkthrough: Creating a Form Based on a Composite Query.

Alternative Designs

It is possible to rebuild a complex query in a data set, a form, a report, and then in a view. But the AOT supports data query designs that are almost as powerful as what the SQL select statement can do natively in the database products. So a better design is to consider building a query business object one time. Then you can reuse that query object in all the form and report objects that need the same data.

See also

Query Framework in the AOT

Forms in Microsoft Dynamics AX

View Basics

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