Livereport - passing values to a 'IN' SQL statement in a Livereport?

Hi there,I am trying to pass an parameter values to a Livereport, which needs to use an ‘IN’ command in the SQL statement, as an example: Select name, dataid from dtree where dataid IN (%1)Question: Which parameter type do I need to use in my Livereport?I have tried to use parameter type 'User Input' and others but it does not work.Parameter1, would be "(1234, 2345)".As long as I don’t use de 'IN' command with multiple dataid, delimited by a comma it works. However, I need to use '(', ')' and ',' characters to pass the SQL statement.How can I pass the quoted field to the Livereport?My customer uses Oracle 10 and Livelink 9.7.1.Thanks for your suggestions in advance!

Find more posts tagged with

Comments

joao_silverio

I just found the solution myself ...For others among us coming across the same issue:1.) Define an InsertString as parameter type.2.) Place the select statement in your Livereport like: select name, dataid from dtree where dataid in (%1)3.) pass the url using encoded html characters.Cheers,Joao Silverio

Hans Stoop

Message from Hans Stoop <hstoop@opentext.com> via eLink

eLink

This option is only available with WebReports and not with the standard LiveReport implementation.

You also may want to consider the security implications of allowing users to do this. They also can enter other texts like subqueries to get access to other data.

Hans

From: eLink Discussion: Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Donnerstag, 28. Juli 2011 11:31
To: eLink Recipient
Subject: I just found the solution myself ...

I just found the solution myself ...		Posted by j.silverio@pzh.nl (Silverio, Joao) on 2011/07/28 05:30
In reply to: Livereport - passing values to a 'IN' SQL statement in a Livereport?		Posted by j.silverio@pzh.nl (Silverio, Joao) on 2011/07/27 12:53

I just found the solution myself ...
For others among us coming across the same issue:

1.) Define an InsertString as parameter type.
2.) Place the select statement in your Livereport like:
select name, dataid from dtree where dataid in (%1)
3.) pass the url using encoded html characters.

Cheers,
Joao Silverio

Attachment Links:

Example 2.JPG (66 KB)

[To reply to this thread, use your normal E-mail reply function.]
Topic:	Livereport - passing values to a 'IN' SQL statement in a Livereport?
Discussion:	Live Reports Discussion
Livelink Server:	knowledge-wlweb01

To Unsubscribe from this Discussion, send an e-mail to unsubscribe.livereportsdiscussion@elinkkc.opentext.com.