Eclipse Community Forums: BIRT

Home » Archived » BIRT » Query question

Thu, 27 October 2005 05:56

Eclipse User

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!

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

Thu, 27 October 2005 16:34

Eclipse User

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!
>
>
>
>

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

Thu, 27 October 2005 17:50

Eclipse User

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!
>>
>>
>>
>>
>
>

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

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 08:45:27 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter