Need help with a BQL command (PXFilteredProcessingJoinOrderBy)

Hi @Joe Schmucker 

I have made several modifications to your code. Please review the details provided below:

1. In the Join, I included the Order Type field. It is strongly advised to use this field as it serves as a KEY field.

2. Please note that the WHERE Clause does not support PXFilteredProcessingJoinOrderBy. Therefore, it is advisable not to include it in your code.

3. To address the issue mentioned above, I have created a view delegate for the view SOLinesToUpdate. In this delegate, I added a Where Clause along with an Order By clause. I am optimistic that this modification will resolve the problem you encountered.

Please incorporate these changes into your code and test it accordingly.

Here is the code:

 public PXFilter<RecordsToProcessFilter> Filter;
        [PXFilterable]
        public PXFilteredProcessingJoinOrderBy<SOLine, RecordsToProcessFilter, InnerJoin<SOOrder, On<SOOrder.orderType,Equal<SOLine.orderType>,And<SOOrder.orderNbr, Equal<SOLine.orderNbr>>>>,
                                            //Where<SOLine.inventoryID, Equal<Current<ICSPricingINItemClass.priceClassID>>,
                                            //And<SOLine.completed, Equal<False>,
                                            //And<SOLine.openQty, Greater<decimal0>,
                                            //And<SOOrder.status, Equal<SOOrderStatus.open>>>>>,
                                            OrderBy<Asc<SOLine.orderNbr, Asc<SOLine.lineNbr>>>> SOLinesToUpdate;

        protected virtual IEnumerable sOLinesToUpdate()
        {
            RecordsToProcessFilter filter = Filter.Current;
            if (filter != null)
            {
                PXSelectBase<SOLine> preparedorder = new PXSelectJoin<SOLine, InnerJoin<SOOrder, On<SOOrder.orderType, Equal<SOLine.orderType>, And<SOOrder.orderNbr, Equal<SOLine.orderNbr>>>>,
                                                          Where<SOLine.inventoryID, Equal<Required<SOLine.inventoryID>>,
                                                          And<SOLine.completed, Equal<False>,
                                                          And<SOLine.openQty, Greater<decimal0>,
                                                          And<SOOrder.status, Equal<SOOrderStatus.open>>>>>,
                                                          OrderBy<Asc<SOLine.orderNbr,Asc<SOLine.lineNbr>>>>(Base);

                return preparedorder.Select(filter.InventoryID);
            }
            return null;
        }