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
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:
Best regards,
Norton
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:
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.
Dear Jitendra,
Unfortunately, it is difficult to determine which the filter exactly is required. However, there is a lot of information about how to create an esq query in the bpmonline academy. Please find more information in the articles by the links below:
https://academy.bpmonline.com/documents/technic-sdk/7-14/entityschemaquery-class-filters-handling
https://academy.bpmonline.com/documents/technic-sdk/7-13/entityschemaquery-filters-handling
https://academy.bpmonline.com/documents/technic-sdk/7-14/creating-detail-selection-lookup
https://academy.bpmonline.com/documents/technic-sdk/7-14/using-filtration-lookup-fields-examples
Best regards,
Norton