Search & Select Prompt - query operator

[Danielbryanuk]

Hi all

Using Cognos 8.3 report studio.

Sorry if this is an obvious one, but I've been racking my brains on it for a while.

I have a search and select prompt which is used to select parameter value(s) to be referenced in a query filter. My filter expression is therefore:

dataitem in ('pSelect&Searchprompt')

As you'll notice with the S&S prompt the user can choose "contains", "starts with" etc. My question therefore is, do I have to change the filter expression operator (ie. "in") depending on the search option selected by the user? How does this work?

Thanks for your help
Dan

 

[Danielbryanuk]

Please ignore - stupid question!