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?
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.
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
As you see, using inner join doesn't meet you requirements, therefore don't use it.
Is there any options using a query to get this information?
Use only one child DS with outer join.
Business Applications communities