Dynamics Community Forum Thread Details

Can't filter On-Handlist form!

I'm trying to filter on hand list form query using a specific warehouse ("DMM")

I'm using the event handler method of the InventSum datasource:

and here's the query after applying my range:

{Query  object a6c07f50: 
SELECT WITH FORCE_PLACEHOLDERS FIRSTFAST FORUPDATE INDEXISHINT SUM(PostedQty), SUM(PostedValue), 
SUM(PhysicalValue), SUM(Deducted), SUM(Registered), SUM(Received), SUM(Picked), SUM(ReservPhysical), 
SUM(ReservOrdered), SUM(OnOrder), SUM(Ordered), SUM(Arrived), SUM(QuotationReceipt), SUM(QuotationIssue), 
SUM(PhysicalInvent), SUM(AvailPhysical), SUM(AvailOrdered), SUM(PdsCWPostedQty), SUM(PdsCWDeducted), 
SUM(PdsCWRegistered), SUM(PdsCWReceived), SUM(PdsCWPicked), SUM(PdsCWReservPhysical), SUM(PdsCWReservOrdered), 
SUM(PdsCWOnOrder), SUM(PdsCWOrdered), SUM(PdsCWArrived), SUM(PdsCWQuotationReceipt), SUM(PdsCWQuotationIssue), 
SUM(PdsCWPhysicalInvent), SUM(PdsCWAvailPhysical), SUM(PdsCWAvailOrdered) 
FROM InventSum(InventSum) 
USING INDEX ClosedItemDimIdx GROUP BY InventSum.ItemId, InventDim.InventLocationId, InventDim.inventBatchId,
InventTable.NameAlias ORDER BY InventSum.ItemId ASC 

WHERE ((Closed = 0)) AND ((InventLocationId = N'DMM'))

JOIN FORUPDATE INDEXISHINT  FROM InventDim(InventDim) USING INDEX DimIdIdx 
ON InventSum.InventDimId = InventDim.inventDimId 

AND ((InventLocationId = N'DMM')) 

JOIN FORUPDATE  FROM InventTable(InventTable_DS) ON InventSum.ItemId = InventTable.ItemId}

But the form still not filtered!