How to select multiple string values in a field on document load trigger

[konidena]

Hi Team,

Here i attached the qvw file for more clarity.

I have to add a trigger in document properties.

Trigger is for "On Open"

Requirement: 

I have name column, salary column

Name               Salary

ramu               3000

srinivasa rao     2000

vikas               5000

I used the expression in the trigger           ='('&'srinivasa rao'&'|'&'ramu'&')'

It is selecting only 'ramu' on qvw open.

If i give "vikas" and "ramu" then it is selecting both.

I am assuming, there is issue with the space in the name "srinivasa rao". How to handle this space.

Regards

Srinivas

[Gysbert_Wassenaar]

Try ='("srinivasa rao"|"ramu")'

[Chanty4u]

chk dis

[sunny_talwar]

This should work also:

("srinivasa rao"|"ramu")

The idea is that when you have space between your search string, you need to use double quotes around the search string.

This should also work:

("srinivasa rao"|ramu)