General X++ Development
How do I create an outer join using QueryBuildDataSource?
How do I create an outer join using QueryBuildDataSource?
1 answer
Write an answerSet the datasource join mode to OuterJoin.
salesDs.joinMode(JoinMode::OuterJoin);The rest of the query is built the same way as an inner join. The difference is that the parent record can still come back when there is no matching child record.
Know the solution?
Sign in to contribute an answer and build your community reputation.
Sign in to answer