Livereport Iinput type to allow multiple values

[rtnesst]

From the Opentext document titled "Application Note - A Technical and Functional Look at Deleting Livelink Users.pdf" I took the report [K] and modified it to take user input - In the LiveReport I specified the first Input as type = number from the dropdown list. I replaced the hardcoded values with %1, and set the Param %1 as "User Input 1" - Here is my SQL Statement in the report...

select p.id "User ID", p.proxyid "Proxy ID", p.proxytype , k.name "User Nmae", m.name "Proxy User" from kuafproxy p, kuaf k, kuaf m where p.id=k.id and p.proxyid = m.id and p.id in (%1)

If I enter a single value in the prompt - the report runs fine but if I enter 2 values seperated by a comma only the first one is returned. What am I doing wrong?

 

[appnair]

if you can make this work as p.id in (%1,%2)adding another user input then this is an extremely educated guess.OT may be putting in their code so that SQLinjection may not happen .When I get time I will check their code.

Also you say you declared themas number so having something like this is not a number 12345,56789 that could be another problem.

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

 

[rtnesst]

Hi,
Thanks for the response. I would actually like to allow the user to input any number of values so using (%1, %2) would limit that, if it would even work. I am interested in your comment about setting the input as a number. I've tried "string" but that did not seem to work either. I've also tried using different characters surrounding the values, like single quotes, double-quotes, square-brackets, Parens, back-quotes - and even droping the comma between the values . . . all to no avail. Maybe you have another sugestion for characters to use? I wonder if Opentext has a document describing what is allowed here? I havent found one yet.

Thanks for you time,
Randy