CODEWITHSUNDEEP
axaptadynamics-ax-2012dataviewaot
Brad
Brad

Reputation: 1369

LEFT JOIN in Dynamics AX View

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

Upvotes: 8

Views: 14499

Answers (1)

Matej
Matej

Reputation: 7627

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

Upvotes: 13

Related Questions