Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Using parameters to update/change query
Migrateduser
Hello,
I have a query in Birt like this:
select count(*)
from aTable
left outer join bTable on aTable.bTable_id = bTable.id
where (? = 'aTable' and aTable.date between {ts ?} and {ts ?})
or (? = 'bTable' and bTable.date between {ts ?} and {ts ?})
I want to be able to change it to this or something similar:
select count(*)
from aTable
left outer join bTable on aTable.bTable_id = bTable.id
where (?)
Where I can update that last parameter to be whatever I want using a function like if aTable then filter on aTable dates. Is this possible? I tried using a function and no luck.
? = aTable.date between DATE_PARAM_1 and DATE_PARAM_2
Thanks
Find more posts tagged with
Comments
There are no comments yet