Please see attached example qvw file. If I click Test button with only one search word (for example Test), then the value is searched in the field MES correctly. However, when I want to search 2 values (for example, Test, Prod), then the search fails completely. In the attached example, search value is stored in a variable. The test button uses the action of Select in field (MES) with the search string as ='*'&'$(vTest)'&'*'
Thanks for your help in resolving this multiple search issue
Mayil,Thanks for your suggestion to your remove the space and to swuehl to fix the space after the comma separator. I see the selection work perfectly now for multiple values as in your attachment Test.qvw. However, if the search word itself has space, the button action doesn't select the rows in MES field. Do you know how to handle if the space is in the search string itself like 'This is Test'? Further, is there a way to count the number of selected rows based on the search and display in a table? I am attaching the test file with the search string with a space when the button action doesn't work as expected.