cancel
Showing results for 
Search instead for 
Did you mean: 

Narrow Results for Wildcard Search in WEBi

JG432
Explorer
0 Kudos
94

Hello, I am using a parameter that is linked to a calculated field as a search bar. The problem I am having is that when I'm searching for a very specific item, it's returning too many unrelated results because of the letters involved. For instance, I have a show title that I'm searching for called 'ION'. When I perform the search, it is returning every word in all of my concatenated data sources containing those letters. Is there a way to narrow the search so all of the other values containing those letters do not show up? I've posted a sample excel file and my calculated field below for viewing. The green entry is my targeted search, the yellow highlighted ones are all what is added when I search 'ION' directly. Thank you as always!

JG432_0-1737744131978.png

CONTAINS(([SHOW NAME]),([Search Parameter]))
or
CONTAINS(([PASSWORDS]),([Search Parameter]))
or
CONTAINS(([POINT OF CONTACTS]),([Search Parameter]))

Accepted Solutions (0)

Answers (0)