LEFT JOIN in Dynamics AX View

Question

Does anyone know how to do a LEFT OUTER JOIN in a Dynamics AX View from the AOT (not a programmatically-created query).

Can't seem to find a way to do anything other than an INNER JOIN, and the documentation seems to indicate it isn't possible.

This seems to be a huge weakness, so I figure if they don't support it, there is a recommended way to accomplish the same thing.

Thanks

Answer 1

You have to create Query and then set the Query property of the View to that query.

On query data sources you can select JoinMode:

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

See: Create a View Based on a Query