var custId = params["CUST_ID"].value; // gets the value of CUST_ID from report parameter

if (custId != null)  {
	// this.queryText refers to the SQL query to be executed by BIRT
	this.queryText = this.queryText + " where id = " + custId;
}

select * from table where integer_col in (
    select integer_col_2 from table2
)

select * from table where string_col in (
    select string_col_2 from table2
)

select * from table where integer_col in (
    select string_col_2 from table2
)

select * from table where integer_col in (12, 24, 55)

select * from table where string_column in ('blah', 'blah', 'blah')

SELECT residency.id
FROM residency
WHERE residency.location_id IN (
    SELECT location.uuid FROM location
    WHERE location.extid IN (
        SELECT ext FROM usertable123
    )
)

SELECT residency.id
FROM residency
WHERE residency.location_id IN (
    SELECT location.uuid FROM location
    WHERE location.extid IN (
        'uservalue1', 'uservalue2', 'uservalue3'
    )
)

         SELECT ext FROM usertable123

        'uservalue1', 'uservalue2', 'uservalue3'

SELECT residency.id
FROM residency
WHERE residency.location_id IN (
    SELECT location.uuid FROM location 
    WHERE location.extid IN (?)
)