I’m wanting to show the qty available in two different warehouses as two columns. The records should all still come through, regardless of whether there is qty available or not. For this reason I used a left join:
But this left join should only be for records from a specific warehouse, so I added the following condition:
I would expect to see all inventory records, but only some are being returned.
Do I have to use a subquery? What is wrong with my condition that can be improved?
+9Hi
You should move the SiteID filter to the relations tab. This will allow you to return the record whether or not the INLocationStatus records exists for that warehouse.
FYI, on the relation you will need to lookup and filter using the integer that represents the SiteID primary key, since the Relation doesn’t offer the ‘From Schema’ option.
Hope this helps!
Laura
+4
Hi
You have to inner join with INSite and INLocationStatus. And use the SiteCD in your relation joins for a particular Warehouse. Take a look at below screenshots. Hope this will help.
I have also attached the GI for your reference.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
