Specifying which field my search bar uses with a control

[pachinko98]

I have a search bar control I created from a parameter and linked to a filter. I would like to set up a control (The one named Search Type) that chooses which field the search bar uses for it’s searches. Is this possible or can controls only be linked to one filter/field?

[yusukez]

Hi @pachinko98 ,

Thank you for reaching out.

Does the following article match what you are looking to achieve?
However, it requires the use of a filter control, not a parameter control.

Relevant values based on filter

It would be great if we could show relevant values based on any filter without the requirement for the filter to be in a control. Currently we can only show relevant values based on the selection in another control. If I have a filter that doesn’t have a control, I cannot have relevant values based on it. Sometimes we apply a filter to a dashboard but we don’t want to expose that filter in a control so that users cannot change it. Because we can’t have relevant values based based on that filter…

Below are an operational image for your reference.

Set relevant values to specific filter.

In this scenario, if we select ‘AMER’ as the value for the ‘Region’ field, it will display only the countries associated with the ‘AMER’ region in the ‘Country’ field.

BR

[ErikG]

Hi @pachinko98
you also could check

Creating cascading filters - Amazon QuickSight

BR

[pachinko98]

Hi @yusukez ,

Thanks for the article and walkthrough! The solution provided filters relevant items but the search bar can only lookup results in one field (The ‘Country’ field). I would like for the “Search Type” control to choose which field to use for the search. So for example using your dataset:

The ‘Search Type’ control would have the options ‘Country’, ‘Industry’, or ‘Product’. If you selected ‘Product’ you would only be able to search within the values of that field.

[yusukez]

Hi @pachinko98 ,

I understand your situation.
It seems you are looking to define a dynamic field using a parameter.

Here are the steps to achieve this:

Step 1: Create the parameter. (In this example, I’ve named it ‘pSelector’.)

Step 2: Define the dynamic field. (In this example, I’ve named it ‘dynamic_field’.)

Step 3: Create a parameter control for the parameter created in Step 1. (In this example, I’ve named it ‘pcSelector’.)

Step 4: Add a filter control for the dynamic field defined in Step 2.

Now, you can search for and select items in ‘dynamic_field’ based on the value selected in ‘pcSelector’.

Example1:

Example2:

BR

[pachinko98]

This was exactly what I needed. Thank you!