Question

Filter in Pricelist Lookup inside the Product in Order

Hi,
I need to show a pricelist lookup items based on organisation role of logged user.

Like:  If i have five option inside the pricelist lookup(Base,Franchisee,RRP,Retail,SellPriceTier) ,

only user based on there organisational role can view only 3 options of lookup values(Base,Franchisee,RRP) and hide other values.

Please suggest me how to make it possible .

Thanks

Like

5 comments

Dear Jitendra,

In order to implement the filter please do the following:

1. Create a replacing client module for the “ProductSelectionSchema” schema.

2. Create the “applyProductPriceItemsEsq” method that should override the corresponding method from the “ProductSelectionQueryUtilitiesMixins” schema.

Please see the screenshot with the code example below:

https://prnt.sc/pdgera

Best regards,

Norton

Thanks for the reply.

Can you please guide me how can I apply the filter in  "Product prices" in the product detail page.
I want to hide some pricelist option from the grid. 

 

Dear Jitendra,

In order to implement the filter please do the following:

1. Create a replacing client module for the “ProductPageV2” schema.

2. Create a method for filtration.

3. Override the “ProductPriceDetail” object from the “details” section. Please see the screenshot with the code example below:

https://prnt.sc/pk2d16

Best regards,

Norton

Norton Lingard,
Thanks for the reply.

 I am facing issue to make filter syntax for the query.
The table relation is as:
Product Pricelist table "ProductPrice" with column ["productId"] ,["PriceListId"].

To provide the pricelist visible lookup with name ["UsrProductPriceFilter"] with column ["UsrPriceList"] of pricelist lookup.

Please help me to write the correct syntax for filter the above list.

 

Log in or register to comment