SBX - Search With Button

SBX - Forum Post Title

Create a query that show alls items of inventTable and pdsCatchWeightUnit

Microsoft Dynamics AX Forum

Javier Biesa asked a question on 14 Sep 2018 10:42 AM
My Badges

Question Status

Verified

Hello

I need to create a query to set it on a view that shows all items of inventTable and of those who have pdsCatchWeightunit must be show.

I created a query with a primary DS and two childs one with inner join and other with outerJoin.

But the outcomes show only items with pdsCatchWeightUnit.

How can I do that?

Regards

Reply
Martin Dráb responded on 14 Sep 2018 11:02 AM

I don't understand what you're trying to achieve by those two datasources for the same table, but the reason why you see only catch weight items is the one with inner join.

Reply
Javier Biesa responded on 15 Sep 2018 12:49 AM
My Badges

That's the problem when doing the inner join, it only shows me the items with the capture weight and I need to be able to see those that have weight captured with their unit and those that do not have a captured weight should see them without the captured weight unit

Reply
Martin Dráb responded on 15 Sep 2018 1:04 AM

As you see, using inner join doesn't meet you requirements, therefore don't use it.

Reply
Javier Biesa responded on 15 Sep 2018 1:18 PM
My Badges

Is there any options using a query to get this information?

Reply
Rustem Galiamov responded on 15 Sep 2018 1:23 PM
My Badges
Verified Answer

Use only one child DS with outer join.

Reply
Rustem Galiamov responded on 15 Sep 2018 1:23 PM
My Badges
Verified Answer

Use only one child DS with outer join.

Reply

SBX - Two Col Forum

SBX - Migrated JS