Dynamics Community Forum Thread Details

filter datasource in form

hi everyone.

this may sound a bit silly but I can't find anything close to what i need to do.

I've created a form with purchline table as the data source and i need to filter by PurchQty field, excluding records that equal to certain add:

basically, I need to only show the record that fulfills this request:

PurchLine.PurchQty != (QtyPurch + PurchLine.RemainPurchPhysical)

where qtyPurch is a calculated field from other tables.

I've done some research in forums but I can only find the opposite result, adding the next line in the executequery method from the data source:

this.query().dataSourceTable(TableNum(PurchLine)).addRange(fieldNum(PurchLine,PurchQty)).value(queryValue(qtyPurch + PurchLine.RemainPurchPhysical));

which return as a said the opposite of what I'm trying to achieve (PurchLine.PurchQty == (QtyPurch + PurchLine.RemainPurchPhysical))

I've found other options to add two value ranges like value == v1 or value == v2 but nothing to compare !=, <, >

is there anyway to do this directly on the datasource?

I hope I made myself clear, if you need more information please let me know.

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

filter datasource in form