I want to add a AND expression as range to wmsInventLocation field in InventDim table. standard is already constructing a query and i need to add additional piece of range.
Scenario : There is a custom field YesNo field(CanReserve) in WMSLocation table. and i can toggle this to multiple records. Now to that above stated standard query, which is ideally selecting invendDim table and i want to add not consider these two location.(the two location that i have marked as CanReverve)
standard query is like : {Query object f60e9670: SELECT WITH SELECT_ORDER SUM(AvailPhysical), SUM(AvailOrdered), SUM(OnOrder) FROM InventSum(InventSum_1) GROUP BY InventSum.ItemId ASC WHERE ((ClosedQty = 0)) AND ((Closed = 0)) AND ((ItemId = N'AK0002')) JOIN * FROM InventDim(InventDim_1) GROUP BY InventDim.InventSiteId ASC, InventDim.InventLocationId ASC, InventDim.wMSLocationId ASC ON InventSum.InventDimId = InventDim.inventDimId AND ((configId = '')) AND ((InventSizeId = '')) AND ((InventColorId = '')) AND ((InventStyleId = '')) AND ((InventSiteId = N'QBR')) AND ((InventLocationId = N'SQS')))}
Now i have added the below piece of code. so i am selection those particular locations and adding as valutNot(<those selected locations>)
but what is happening is, the query is adding those ranges are OR condition.
{Query object f60e9670: SELECT WITH SELECT_ORDER SUM(AvailPhysical), SUM(AvailOrdered), SUM(OnOrder) FROM InventSum(InventSum_1) GROUP BY InventSum.ItemId ASC WHERE ((ClosedQty = 0)) AND ((Closed = 0)) AND ((ItemId = N'AK0002')) JOIN * FROM InventDim(InventDim_1) GROUP BY InventDim.InventSiteId ASC, InventDim.InventLocationId ASC, InventDim.wMSLocationId ASC ON InventSum.InventDimId = InventDim.inventDimId AND ((configId = '')) AND ((InventSizeId = '')) AND ((InventColorId = '')) AND ((InventStyleId = '')) AND ((InventSiteId = N'QBR')) AND ((InventLocationId = N'SQS')) AND ((NOT (wMSLocationId = N'LOS')) OR (NOT (wMSLocationId = N'PLO')))}
Since it is OR, its only negletting the value LOS, and its considering the quantity from PLO even though its marked as reserve.
So instead of this or, how can i add AND?
I want to have that code looks like
Can anyone help me on this.
