Filter "IN" Syntax - Help

millvall

Hi folks,
I'm struggling with the "IN" Filter format.
Tried various patterns to retrieve multiple rows....not winning.
Would appreciate any help.
Simple report attached if you want to try.
(Ac BIRT 10sp1)

Thanks
Milt.

Steps:
1) Open report in AC BIRT
2) Select the HTML button labeled "Filter Table" and click Script
3) Alter the IN syntax.
4) Run in the web viewer (will not work in Preview)
5) Click the button to see if rows expected are returned.



Tried:

// filter = new actuate.data.Filter("CITY", "In", "London"); // GOOD! Only London

// filter = new actuate.data.Filter("CITY", "In", "London,Boston"); // BAD London only
// filter = new actuate.data.Filter("CITY", "In", "London;Boston"); // BAD
// filter = new actuate.data.Filter("CITY", "In", "London Boston"); // BAD - no rows
// filter = new actuate.data.Filter("CITY", "In", "'London' ; 'Boston'"); // BAD - no rows
// filter = new actuate.data.Filter("CITY", "In", "'London' , 'Boston'"); // BAD - no rows
// filter = new actuate.data.Filter("CITY", "In", '"London ; Boston"'); // BAD - no rows

-- eom --

JasonW

I could not get the report to work with the //good line
Can you try

filter = new actuate.data.Filter("CITY", "In", "'London':'Boston'");