Retain Adaptive Search Filters with Query-Based Product Filtering in Leads — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Retain Adaptive Search Filters with Query-Based Product Filtering in Leads

edited Jul 11, 2025 7:52AM in Sales 3 comments

Hi @John Vakoc-Oracle and Team,

We are currently using Adaptive Search filters in the Product field on the Leads page to allow users to filter products by Product Category. This works well when using the default configuration, without any custom query.

However, we now have a requirement to filter products based on the selected Business Unit. To achieve this, we added a query in the picker template like this:

<oj-vb-fragment-param name="query" value="[[ {type: 'qbe', provider: 'adfRest', params: [{ key: 'BusinessUnit_c', value: $variables.BusinessUnitCustom }] }]]" />

After implementing this query, the product list correctly filters based on the Business Unit, but the

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!