Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Filtering dataset with multiple filters
Filtering dataset with multiple filters [message #1218957] Fri, 29 November 2013 14:16 Go to next message
mkrivic Mising name is currently offline mkrivic Mising nameFriend
Messages: 33
Registered: May 2010
Member
Hi,

I am doing some multiple filterings on existing BIRT dataset.

Filtering is being done with report parameter, data type string, display type list.

For first parameter (work_week list), in filter, I 've built this JS code:

match = 0;

for( ii=0; ii<params["work_week"].length;ii++){
if ( row["weekName"] == params["work_week"].value[ii] ){
match = 1;
}
}
match;

So, every time when this statement is true, I can get my filtered rows.

But when I build another filter for other report parameter, I build existing code (of course, with different names of variables and params), it doesn't work.

Does anyone know how I can filter data set on multiple parameters, because operator in works for only one selected value from report parameter list, not for more selected values.

Thanks,
Re: Filtering dataset with multiple filters [message #1219443 is a reply to message #1218957] Tue, 03 December 2013 21:53 Go to previous message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

Why not create an expression that checks against all of your parameters and passes a true or false just once rather than creating multiple filters. Maybe I'm misunderstanding. Let me know.

Michael

Developer Evangelist, Silanis
Previous Topic:Birt CSV report issue
Next Topic:Line Chart displays null values as 0
Goto Forum:
  


Current Time: Tue Mar 19 07:29:45 GMT 2024

Powered by FUDForum. Page generated in 0.02017 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top