I have a Multi-Select List of Values (Check Box) input control named Animal Categories, with the following values:
Name Value
Birds 1
Mammals 2
Amphibians 3
and a Single Select Query input control named Country, with the following values:
Brazil
Australia
Portugal
The Country's SQL Query show values on when Amphibians is selected from the Animal Categories.
-- Some Oracle SQL Code
WHERE $X{IN, 3, animalcategory}
What I want now is to make Country input control a Multi-Select List of Values (Check Box) and keeping showing the values when the Amphibians is selected from the Animal Categories, but I don't know how to do that, since I have a List now and not a Query to be based on the Animal Categories' values.