Using parameters to perform arbitrary search for column values (wildcard search)

In a previous article we described the out-of-box feature to perform wildcard search using drop down filter widgets

However sometimes this is less convenient due to the large set of data being returned. Or you want more flexibility on the search, for example you want to be able to have multiple keywords.

This will require the use of parameters & custom filters. Refer to this introductory training video for the fundamentals behind parameters.

You will need to use “custom filter” as shown here:
image

And apply custom parameter expression to the filter shelf of the visual like the following:

       lower([customer_name]) like '%<<keyword1>>%' 

Here’s a video of setting up wildcard search using two strings entered in different input boxes.

2 Likes