How to create a Multiple Selector

Hi @Naveen Boga 

I have modified the view as following code but it doesn’t work. I guess there is an issue with condition Where<INReplenishmentItem.siteID, In<Current<INReplenishmentFilterExt.usrWarehouse»

I tried with Where<Current<INReplenishmentFilterExt.usrWarehouse>, Contains<INReplenishmentItem.siteID> but it does not work too :(

Could you please have a look and and instruct me?

[PXFilterable]
        public Processing<INReplenishmentItem> Records;
        //If update Acmatica to later version need to check this function to update it to latest code from Acumatica (keep use INReplenishmentItem.siteID in INReplenishmentFilterExt.usrWarehouse
        public class Processing<Type> :
            PXFilteredProcessingJoin<INReplenishmentItem, INReplenishmentFilter,
            LeftJoin<INItemClass, On<INReplenishmentItem.FK.ItemClass>>,
        Where<INReplenishmentItem.siteID, In<Current<INReplenishmentFilterExt.usrWarehouse>>,//The original is: Where<INReplenishmentItem.siteID, Equal<Current<INReplenishmentFilter.replenishmentSiteID>>
            And2<Where<
                Current<INReplenishmentFilter.itemClassCDWildcard>, IsNull,
                Or<INItemClass.itemClassCD, Like<Current<INReplenishmentFilter.itemClassCDWildcard>>>>,
            And2<Where<
                INReplenishmentItem.launchDate, IsNull,
                        Or<INReplenishmentItem.launchDate, LessEqual<Current<INReplenishmentFilter.purchaseDate>>>>,
            And<Where<
                INReplenishmentItem.terminationDate, IsNull,
                        Or<INReplenishmentItem.terminationDate, GreaterEqual<Current<INReplenishmentFilter.purchaseDate>>>>>
            >>>>
        where Type : INReplenishmentItem
        {

            public Processing(PXGraph graph)
                : base(graph)
            {
                this._OuterView = new PXView(graph, false, BqlCommand.CreateInstance(
                    typeof(
                        Select2<INReplenishmentItem,
                        LeftJoin<INItemClass, On<INReplenishmentItem.FK.ItemClass>>,
                        Where<INReplenishmentItem.siteID, In<Current<INReplenishmentFilterExt.usrWarehouse>>,//The original is: Where<INReplenishmentItem.siteID, Equal<Current<INReplenishmentFilter.replenishmentSiteID>>
                        And2<Where<
                            Current<INReplenishmentFilter.itemClassCDWildcard>, IsNull,
                            Or<INItemClass.itemClassCD, Like<Current<INReplenishmentFilter.itemClassCDWildcard>>>>,
                        And2<Where<
                            INReplenishmentItem.launchDate, IsNull,
                        Or<INReplenishmentItem.launchDate, LessEqual<Current<INReplenishmentFilter.purchaseDate>>>>,
                        And<Where<
                            INReplenishmentItem.terminationDate, IsNull,
                        Or<INReplenishmentItem.terminationDate, GreaterEqual<Current<INReplenishmentFilter.purchaseDate>>>>>
                        >>>>)));

                this._OuterView.WhereAndCurrent<INReplenishmentFilter>(nameof(INReplenishmentFilter.itemClassCDWildcard), nameof(INReplenishmentFilter.itemClassCD));
                this._OuterView.WhereAnd<Where<Current<INReplenishmentFilter.onlySuggested>, Equal<False>, Or<INReplenishmentItem.qtyProcessInt, Greater<decimal0>>>>();
            }
        }

Here is the definition of UsrWarehouse field

public class INReplenishmentFilterExt : PXCacheExtension<PX.Objects.IN.INReplenishmentFilter>
    {
        #region UsrWarehouse
        [PXSelector(typeof(INSite.siteCD), typeof(INSite.siteCD), typeof(INSite.descr), ValidateValue = false)]
        [PXUIField(DisplayName = "Warehouse")]

        public virtual string UsrWarehouse { get; set; }
        public abstract class usrWarehouse : PX.Data.BQL.BqlString.Field<usrWarehouse> { }
        #endregion
    }