How to filter picker to list only specific products?

Discussion created by pleiades on Jun 16, 2017
Latest reply on Jun 16, 2017 by philmodjunk




I have a product list that have product type of either "Buy" or "Sell".



I like to separate the two into 2 pickers set, one is for products with Buy product type and the other is for products with Sell product type



I like to ask advice on how to filter the picker to only list "Buy" products?



I added a code inside script "pp: update" to find only "Buy" products but if you search for another product, it will show all products again.



the code is

Enter Find Mode []

Set Variable [products::product_type, "Buy"]

Perform Find[]



I have attached the file to explain better.