Filter grid records by custom field

@mrthanhkhoi  Please use below code and verify

[PXFilterable]
public PXSelectJoin<APVendorPrice,
		LeftJoin<InventoryItem, On<InventoryItem.inventoryID, Equal<APVendorPrice.inventoryID>>,
		LeftJoin<INItemClass, On<INItemClass.itemClassID, Equal<InventoryItem.itemClassID>>,
		LeftJoin<Vendor, On<APVendorPrice.vendorID, Equal<Vendor.bAccountID>>,
		LeftJoin<INSite, On<APVendorPrice.siteID, Equal<INSite.siteID>>>>>>,
		Where2<Where<Vendor.bAccountID, IsNull, Or<Match<Vendor, Current<AccessInfo.userName>>>>,
		And2<Where<InventoryItem.inventoryID, IsNull, Or<Match<InventoryItem, Current<AccessInfo.userName>>>>,
		And2<Where<INItemClass.itemClassID, IsNull, Or<Match<INItemClass, Current<AccessInfo.userName>>>>,
		And2<Where<APVendorPrice.siteID, IsNull, Or<Match<INSite, Current<AccessInfo.userName>>>>,
		And<InventoryItem.itemStatus, NotEqual<INItemStatus.inactive>,
		And<InventoryItem.itemStatus, NotEqual<InventoryItemStatus.unknown>,
		And<InventoryItem.itemStatus, NotEqual<INItemStatus.toDelete>,
        And<Vendor.termsID,Equal<Current<APVendorPriceFilterExt.usrShippingTermID>>
		And2<Where<APVendorPrice.vendorID, Equal<Current<APVendorPriceFilter.vendorID>>, Or<Current<APVendorPriceFilter.vendorID>, IsNull>>, 
		And2<Where<APVendorPrice.inventoryID, Equal<Current<APVendorPriceFilter.inventoryID>>, Or<Current<APVendorPriceFilter.inventoryID>, IsNull>>,
		And2<Where<APVendorPrice.siteID, Equal<Current<APVendorPriceFilter.siteID>>, Or<Current<APVendorPriceFilter.siteID>, IsNull>>,
		And2<Where2<Where2<Where<APVendorPrice.effectiveDate, LessEqual<Optional2<APVendorPriceFilter.effectiveAsOfDate>>, Or<APVendorPrice.effectiveDate, IsNull>>, 
		And<Where<APVendorPrice.expirationDate, GreaterEqual<Optional2<APVendorPriceFilter.effectiveAsOfDate>>, Or<APVendorPrice.expirationDate, IsNull>>>>,
		Or<Optional2<APVendorPriceFilter.effectiveAsOfDate>, IsNull>>,
			And<Where2<Where<Current<APVendorPriceFilter.itemClassCD>, IsNull,
					Or<INItemClass.itemClassCD, Like<Current<APVendorPriceFilter.itemClassCDWildcard>>>>,
			And2<Where<Current<APVendorPriceFilter.ownerID>, IsNull,
				Or<Current<APVendorPriceFilter.ownerID>, Equal<InventoryItem.productManagerID>>>,
			And2<Where<Current<APVendorPriceFilter.myWorkGroup>, Equal<boolFalse>,
				 Or<InventoryItem.productWorkgroupID, IsWorkgroupOfContact<CurrentValue<APVendorPriceFilter.currentOwnerID>>>>,
			And<Where<Current<APVendorPriceFilter.workGroupID>, IsNull,
				Or<Current<APVendorPriceFilter.workGroupID>, Equal<InventoryItem.productWorkgroupID>>>>>>>>>>>>>>>>>>>>,
		OrderBy<Asc<InventoryItem.inventoryCD,
			Asc<APVendorPrice.uOM, Asc<APVendorPrice.breakQty, Asc<APVendorPrice.effectiveDate>>>>>> Records;

hello @Naveen Boga, thank you for your answer but I’m so sorry I didn’t describe it clearly.

The idea is I want to create a new data view delegate and select the same data with some additional filtering or dynamic calculations. However, I don’t want to create a new view as your answer because it has  a risk that Acumatica will update this command in the future.

So I suppose if we could customize the view delegate by creating graph extension, something like this

public class APVendorPriceMaint_Extension : PXGraphExtension<APVendorPriceMaint>
{

    public IEnumerable records()
    {

        // 1. get records return from base statement (the source code of Acumatica)
        // 2. get value of APVendorPriceFilterExt.usrShippingTermID
        // 3. filter records from step 1 by additional condition from step 2

    }
}

But I don’t know how to get the records return from original statement in graph extension