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

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'

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:Bug: MySQL Connection only works in connection dialog
Next Topic:Migration from 3.7.2 to 4.8
Goto Forum:

Current Time: Tue Sep 29 09:54:22 GMT 2020

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

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

Back to the top