I have a requirement to search on a user input through a parameter. So say i want to filter a view by a user defined parameter "Fruits"
if the user enters mango I want my view to be filtered with values mango.
If the user enters mango;apple I want it to be filtered by mango or apple. I need to create an implied or between the two values. Is there any way of doing this. I am not sure how many values will the user enter. He might enter 5 he might enter just one.
See if using the CONTAINS clause helps.
Syntax: CONTAINS([Dimension Value],[Parameter Value])