Eclipse Community Forums: BIRT

Help

Home

Home » Archived » BIRT » Query question

Show: Today's Messages :: Show Polls :: Message Navigator

Query question [message #84701]

Thu, 27 October 2005 09:56

mr. burns

Messages: 402
Registered: July 2009

Senior Member

Hello,

I tried to use following query in a dataset:

SELECT * FROM MyTable WHERE ?

And the I added a parameter called dsParam1 with default value:

"Amount > 1000"

So the query should be combined by BIRT to:

SELECT * FROM MyTable WHERE Amount > 1000

If I test the result preview there is no result. Only the column headers are
shown, now result even if there are records with Amount > 1000.
So my quetions are those parameters allowed?

Thanks a lot for help!

Report message to a moderator

Re: Query question [message #84973 is a reply to message #84701]

Thu, 27 October 2005 20:34

Marty Jones

Messages: 18
Registered: July 2009

Junior Member

Mr. Burns,

I am new to Birt but I believe you have to specify the "Amount > ?" in your
where clause of your query and just specify the actual parameter within the
parameter window.

"Mr. Burns" <Mr._Burns@web.de> wrote in message
news:djq87l$8tq$1@news.eclipse.org...
> Hello,
>
> I tried to use following query in a dataset:
>
> SELECT * FROM MyTable WHERE ?
>
> And the I added a parameter called dsParam1 with default value:
>
> "Amount > 1000"
>
> So the query should be combined by BIRT to:
>
> SELECT * FROM MyTable WHERE Amount > 1000
>
> If I test the result preview there is no result. Only the column headers
> are shown, now result even if there are records with Amount > 1000.
> So my quetions are those parameters allowed?
>
> Thanks a lot for help!
>
>
>
>

Report message to a moderator

Re: Query question [message #85048 is a reply to message #84973]

Thu, 27 October 2005 21:50

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

Mr. Burns,

Marty is correct. You can modify the whole query in the BeforeOpen method
if you need to do something like append to the SQL.

Jason Weathersby
BIRT PMC

"Marty Jones" <marty_jones@dailyaccess.com> wrote in message
news:djrdl2$ur8$1@news.eclipse.org...
> Mr. Burns,
>
> I am new to Birt but I believe you have to specify the "Amount > ?" in
> your where clause of your query and just specify the actual parameter
> within the parameter window.
>
>
> "Mr. Burns" <Mr._Burns@web.de> wrote in message
> news:djq87l$8tq$1@news.eclipse.org...
>> Hello,
>>
>> I tried to use following query in a dataset:
>>
>> SELECT * FROM MyTable WHERE ?
>>
>> And the I added a parameter called dsParam1 with default value:
>>
>> "Amount > 1000"
>>
>> So the query should be combined by BIRT to:
>>
>> SELECT * FROM MyTable WHERE Amount > 1000
>>
>> If I test the result preview there is no result. Only the column headers
>> are shown, now result even if there are records with Amount > 1000.
>> So my quetions are those parameters allowed?
>>
>> Thanks a lot for help!
>>
>>
>>
>>
>
>

Report message to a moderator

Previous Topic:	How to change properties in OnRow, OnCreate etc.?
Next Topic:	New ODA Datasource

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 05 15:03:50 GMT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter