nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Simplifing filter paramters

sommeralex

Hi, 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) What i get is that i first have to define the query select[color=#000000;] [/color]*[color=#000000;] [/color][color=#931a68;]from[/color] public.ibalarm 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: select[color=rgb(0,0,0);] [/color]*[color=rgb(0,0,0);] [/color][color=rgb(147,26,104);]from[/color] public.alarm where alarm.date < x && alarm.date > y and then, somewhere in a filter method, to SET this x, y filter.setParamter("y", yValue)filter.setParameter("x", xValue) So please can someone explain me how to make this with the latest framework? thxalex

Find more posts tagged with

Comments

mwilliams

If you're wanting parameters that the user enters to change the query params, you're probably looking for something like: select *from public.alarmwhere alarm.date between ? and ? or something like that. Then, in the parameter section of the dataSet editor, you'd link your two dataSet parameters to the the report parameters you created in the Data Explorer. Maybe I'm misunderstanding something. Let me know.