Create a dataset that returns the “parent” values . Add filter A and connect it to that dataset field. Create a dataset for “child” values whose query is parameterized by the parent selection, or simply filters on the parent field:
Configure the filter widget’s Fields to use description from the choices dataset, and its Parameters to set :product_desc_param. Your query looks up the associated ID after selection. This gives users friendly labels while your query operates on IDs
