How to: Create a Document Query [AX 2012]
Updated: February 1, 2013
Applies To: Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
This topic describes how to create a document query that is the basis of an Application Integration Framework (AIF) document service. For more information about document services, see AIF Document Services. The document query is a standard Microsoft Dynamics AX query that is associated with an Axd <Document> class. The document query has the following characteristics:
In an outbound exchange, the query retrieves the data that populates the document.
The document query is the basis from which the document schema is defined. The document schema specifies all the data elements that are valid for the document in either an inbound or outbound exchange.
Document queries are located in the AOT under the Queries node. The query name matches that of the document class that has which it is associated. For example, if you create a document query named AxdCustomer then the document class that is generated will be AxdCustomer.
Before creating a document query and service, you should verify that the Axd class does not already exist. You can view the Axd classes in the AOT. If a class already exists, you must be careful when you name objects so that they do not conflict with the existing AIF classes.
The first step in creating the query is to determine which tables contain the information that is being exchanged by the document.
To find the tables that are used in a functional process, it is helpful to examine the form data sources in the AOT. In order to look up the form in the AOT, you must know the form class name. To find the AOT form class name, open a form that is used in a process. Right-click the form and then select Personalize. You can also use SQL trace to discover what database objects are being accessed during a process. For more information about tracing options, see Setting Up the Tracing Tools.
In this section you will create the document query.
To create the document query
In the AOT, right-click Queries, and then click New Query.
Expand the node for the new query that is named something like Query1.
In the AOT, right-click Data Dictionary, and then click Open New Window.
Expand the Tables node. Drag the table that contains the information that you want to exchange from the second window onto the Data Sources node under the new query in the first window. By default, all the fields in the data source are included in the query.
For more information about how to create a query, see How to: Create Queries by using the AOT.
Rename the query data source table to remove the _1.
If your scenario has multiple data sources, see How to: Add Multiple Data Sources to a Query.
Right-click the new query, click Properties, and then set the Name property to Axd <document>.
As a best practice, the query name should always be the same as the document class name. This is especially true when you use the AIF Document Service Wizard to generate the service because it defaults the document class name to that of the query.
Save the query.
After you have created the document query, you can create the service. For more information, see How to: Create a Service by Using the AIF Document Service Wizard.