LEFT JOIN in Dynamics AX View

axapta dynamics-ax-2012 dataview aot
Brad picture Brad · Nov 24, 2014 · Viewed 9.8k times · Source

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

Matej picture Matej · Nov 24, 2014

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

Related questions

How to invoke a menu item from code in AX 2012

I have some custom code in PurchTable "Register" menuitem's clicked method, Now I need to run the Register command from code after a buttons function has been perfomed. My question is that how can I call the Register command from …

Read More
How to set a single dimension value in AX 2012?

My problem is setting some dimension values read from an external source. Given the AX 2009 statement: ledgerJournalTrans.Dimension = ledgerTable.Dimension; ledgerJournalTrans.Dimension[1] = "abc"; What is the equivalent way to that in AX 2012? This will of cause assume the existence of …

Read More
SSRS report parameter.label showing parameter.value

I have a SSRS report, in my report I have a dataset which has an ID and NAME field, then I created a parameter and set its value to ID from dataset and Label to NAME of dataset. I can …

Read More