Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » How to add a parameter to a SQL Query ?
How to add a parameter to a SQL Query ? [message #1804200] Wed, 20 March 2019 09:48 Go to next message
Frédéric Cantenot is currently offline Frédéric CantenotFriend
Messages: 1
Registered: March 2019
Junior Member
Hi,

I would like to add a dynamic parameter in addition to parameters from Maximo inside SQL query.

Something like that :
select * 
from workorder a 
where params["where"] or a.parent = :Param


with params["where"] which contains wonum='1234'

I need to know if I can set the value of a.Parent with the value of wonum so '1234'

Thanks
Re: How to add a parameter to a SQL Query ? [message #1804315 is a reply to message #1804200] Fri, 22 March 2019 10:54 Go to previous message
Dominik Löwenstein is currently offline Dominik LöwensteinFriend
Messages: 3
Registered: March 2019
Junior Member
select * from ....
where ID = ?

Then u have to set in your dataset a new parameter and choose the linked report parameter.
The name of this par is not important, the first "?" is for the first parameter in your query and so on....
Previous Topic:Cannot get result set metadata
Next Topic:Migration from 3.7.2 to 4.8
Goto Forum:
  


Current Time: Sun Jul 21 04:23:01 GMT 2019

Powered by FUDForum. Page generated in 0.01905 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top