Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » 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:Bug: MySQL Connection only works in connection dialog
Next Topic:Migration from 3.7.2 to 4.8
Goto Forum:
  


Current Time: Tue Mar 19 10:51:17 GMT 2024

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

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

Back to the top