On my processing page, I have a filter to select based on an inventory item.
It is working and selecting rows for my grid using this BQL
public PXFilteredProcessingJoin<SOLine, RecordsToProcessFilter, InnerJoin<SOOrder, On<SOOrder.orderNbr, Equal<SOLine.orderNbr>>>,
Where<SOLine.inventoryID, Equal<RecordsToProcessFilter.inventoryID.FromCurrent>,
And<SOLine.completed, Equal<False>,
And<SOLine.openQty, Greater<decimal0>,
And<SOOrder.status, Equal<SOOrderStatus.open>>>>>> SOLinesToUpdate;
I want to add OrderBy so that the lines are displayed in order by Sales Order Nbr, Line Nbr.
This is the BQL I cannot get to compile
public PXFilteredProcessingJoinOrderBy<SOLine, RecordsToProcessFilter, InnerJoin<SOOrder, On<SOOrder.orderNbr, Equal<SOLine.orderNbr>>>,
Where<SOLine.inventoryID, Equal<RecordsToProcessFilter.inventoryID.FromCurrent>,
And<SOLine.completed, Equal<False>,
And<SOLine.openQty, Greater<decimal0>,
And<SOOrder.status, Equal<SOOrderStatus.open>>>>>,
OrderBy<Asc<SOLine.orderNbr, Asc<SOLine.lineNbr>>>> SOLinesToUpdate;
This is the error message
It looks like all my < and > are accounted for.
If I get rid of the Where section, it compiles, but it returns all rows. I need the Where to restrict the result set in the grid.
This one compiles and works but returns all rows (as in EVERY ROW in the SOLine table)
public PXFilteredProcessingJoinOrderBy<SOLine, RecordsToProcessFilter,
InnerJoin<SOOrder, On<SOOrder.orderNbr, Equal<SOLine.orderNbr>>>,
OrderBy<Asc<SOLine.orderNbr, Asc<SOLine.lineNbr>>>> SOLinesToUpdate;
Any ideas how I can add my Where into this so that it compiles?
Best answer by Naveen Boga
View original