Dynamics Community Forum Thread Details

X++ dynamics Queries + How to add AND condition in the same field of a table.

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