#Transtype 4 alternative code

QbDataSource3 = query2.dataSourceName('SalesOrderLine_1') The QueryFilter class was not in Microsoft Dynamics AX 2009. The following job adds another join filter criteria which tests whether the Quantity field equals 66. The QrySalesAndLines query joins the parent and child tables on an equality test between parent's primary key field and child's foreign key field.

#Transtype 4 alternative code

The following X++ code example uses the QueryFilter class to filter the result set from an outer join. The SalesOrderID value 2 does not occur in the data for SalesOrderLine table. The SalesOrderLine table contains a foreign key field, named SalesOrderID, that references the primary key column of the SalesOrder table. There are two rows in the SalesOrder table.

There are 0 or more rows in the SalesOrderLine table for each row in the SalesOrder table. There is a 1-to-many relationship between the SalesOrder parent table and the SalesOrderLine child table. The field types and sample data are included. This section shows two tables that the code examples in this topic rely on.

Tables and Test Data for this DemonstrationĬode Example with the QueryBuildRange Class The present topic contains the following sections: For more information, see Select Statement with an Outer Join. It produces results that match what you get from X++ SQL with an OUTER JOIN. Applying the filters on the WHERE clause can produce a result set that contains no records that are built from default values.Īs an alternative way to filter an outer join query, you can use the QueryBuildRange class. The Application Object Server (AOS) sends standard SQL to the underlying database management system. Filters that are specified on the WHERE clause are applied later in the process than filter on the ON keyword. The QueryFilter class applies the filters to the WHERE clause in standard SQL, instead of to the ON keyword of the JOIN clause. In Microsoft Dynamics AX, the QueryFilter class gives you a way to filter the result set of an outer join to obtain a different outcome than you can obtain from X++ SQL. Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012