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
Developing Analytics Applications
Simplifing filter paramters
Migrateduser
<p>Hi, </p><p> </p><p>I am using BIRT the first time and it "feels" a little complex to filter DB data. What i need (and still don't understand how it works) is to filter my results in the DB via date (pastDate < x < futureDate)</p><p> </p><p>What i get is that i first have to define the query</p><p> </p><p style="font-size:11px;font-family:Monaco;color:rgb(147,26,104);">select[color=#000000;] [/color]*[color=#000000;] [/color]</p><p style="font-size:11px;font-family:Monaco;">[color=#931a68;]from[/color] public.ibalarm</p><p style="font-size:11px;font-family:Monaco;"> </p><p style="font-size:11px;font-family:Monaco;">but what I do not get is how i can add the where clause to fit my need for a date-filtering. What i would love to have is something like this:</p><p style="font-size:11px;font-family:Monaco;"> </p><p style="font-size:11px;font-family:Monaco;color:rgb(147,26,104);">select[color=rgb(0,0,0);] [/color]*[color=rgb(0,0,0);] [/color]</p><p style="font-size:11px;font-family:Monaco;">[color=rgb(147,26,104);]from[/color] public.alarm where alarm.date < x && alarm.date > y</p><p style="font-size:11px;font-family:Monaco;"> </p><p style="font-size:11px;font-family:Monaco;">and then, somewhere in a filter method, to SET this x, y</p><p style="font-size:11px;font-family:Monaco;"> </p><p style="font-size:11px;font-family:Monaco;">filter.setParamter("y", yValue)</p><p style="font-size:11px;font-family:Monaco;">filter.setParameter("x", xValue)</p><p style="font-size:11px;font-family:Monaco;"> </p><p style="font-size:11px;font-family:Monaco;">So please can someone explain me how to make this with the latest framework?</p><p style="font-size:11px;font-family:Monaco;"> </p><p style="font-size:11px;font-family:Monaco;">thx</p><p style="font-size:11px;font-family:Monaco;">alex</p>
Find more posts tagged with
Comments
There are no comments yet