Multiple values in a user input

Betsy_Kowan

Hi,I would like to create a Livereport with an user input that can take multiple values.I want to achieve something equivalent to this in SQLselect * from table1 where id in (1, 2, 3)where 1, 2, 3 will be user inputs.I tried typing (1,2,3) but it reads it as one string rather than 3 different values.Anybody who can help please? Thank you in advance.Peter

Lindsay_Davies

Message from Lindsay Davies via eLinkHi Peter,Use three inputs... Select * from table1 where id in (%1, %2, %3) %1 = user input 1 %2 = user input 2 %3 = user input 3 RegardsLindsayOpen TextUK-Support-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: 14 March 2007 17:26To: eLink RecipientSubject: Multiple values in a user inputMultiple values in a user inputPosted by Chan, Peter on 03/14/2007 01:23 PMHi,I would like to create a Livereport with an user input that can takemultiple values.I want to achieve something equivalent to this in SQLselect * from table1 where id in (1, 2, 3)where 1, 2, 3 will be user inputs.I tried typing (1,2,3) but it reads it as one string rather than 3different values.Anybody who can help please? Thank you in advance.Peter[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/llisapi.dll/open/2249677Livelink Server:https://knowledge.opentext.com/knowledge/llisapi.dllTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.