LEFT JOIN in Dynamics AX View

Question

Does anyone know how to make a LEFT OUTER JOIN in a Dynamics AX view from AOT (rather than a programmed programmatic request).

There seems to be no way to find a way to do anything other than INNER JOIN, and the documentation seems to indicate that this is not possible.

This seems like a huge weakness, so I believe that if they do not support it, there is a recommended way to do the same.

thanks

Answer 1

You need to create a query, and then set the Query property of the view to this query.

In the query data sources, you can select JoinMode :

• InnerJoin - creates an INNER or CROSS JOIN
• OuterJoin - Creates LEFT JOIN
• ExistsJoin - creates WHERE EXISTS (...)
• NotExistsJoin - creates WHERE NOT EXISTS (...)

See: Create a query based view