Thank you globalbear for your response!!
The issue is, the user can input any number of search strings. Is there any javascript that can be used in this prompt that can collect the input string and concatenate it with '%'? I contacted cognos support but they said it cannot be done. Please help...
Hi ymonge,
Thanks much for your response!!
It works if it is just A, WAN or AMERI but the user can input any string, so how can I get the user inputs and use them in the prompt with multiselect wild card string inputs
i.e the user can view the customer names that starts with the user inputs...
Hi All,
User would like to search for customer names that starts with 'A%' or 'WAN%' or 'AMERI%' etc. Is it possible to use in operator with like operator?
Normally, in a query we use
where ((CustName like 'A%') or (CustName like 'WAN%') or (CustName like 'AMERI%'))
How do we get this in a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.