Hi,
I have a LiveReport which receives an input parameter as a list of comma separated strings. This parameter is then used in the where clause [ie. ... WHERE X in (%1)]. the parameter is defined as a String type. When running the LiveReport by supplying value of the parameter like string1, string2,string3, it always returns no result. If I only supply one of the string such as string1, it returns the expected result. I also tried different style of the string format such as 'string1', 'string2, 'string3', still no luck.
However, the correct results returns when i tested it in SQL Developer. I can't pass the values in different parameters since the paremeter contains a dynamic list of strings.
through further testing, I see where the problem is. The comma separated string is prcoessed as a single quoted string, and that explains why the result returns correctly when just supply one string, so the example list is processed as 'string1, string2, string3' instead of 'string1', 'string2', 'string3'. How can i get it returned as a comma separated list? Content Server always insert a quote when you add a single quote in part of the string list. so string1', 'string2', 'string3 will be processed as 'string1'', ''string2'', ''string3'
How to get rid of the auto inserted single quote?
Any help would be greatly appreciated!
Nikki
I have a LiveReport which receives an input parameter as a list of comma separated strings. This parameter is then used in the where clause [ie. ... WHERE X in (%1)]. the parameter is defined as a String type. When running the LiveReport by supplying value of the parameter like string1, string2,string3, it always returns no result. If I only supply one of the string such as string1, it returns the expected result. I also tried different style of the string format such as 'string1', 'string2, 'string3', still no luck.
However, the correct results returns when i tested it in SQL Developer. I can't pass the values in different parameters since the paremeter contains a dynamic list of strings.
through further testing, I see where the problem is. The comma separated string is prcoessed as a single quoted string, and that explains why the result returns correctly when just supply one string, so the example list is processed as 'string1, string2, string3' instead of 'string1', 'string2', 'string3'. How can i get it returned as a comma separated list? Content Server always insert a quote when you add a single quote in part of the string list. so string1', 'string2', 'string3 will be processed as 'string1'', ''string2'', ''string3'
How to get rid of the auto inserted single quote?
Any help would be greatly appreciated!
Nikki
