Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

multiselect list in where condition

642863Jun 13 2008 — edited Jun 16 2008
Hi,
I use a multiselect list which is like that

All
01
02
03
04
...

I'va got a column name "departement" in my report and i want, if users have selected multiple values, to displaying the row that contains :

where departemet = '01' or departement = '02' if user select 01 and 02

or

where departement = '01' or departement = '02' or departement = '03' if '01', 02 and 03 are selected

how can i do that cause i don't know the number of conditions ?

thx

Message was edited by:
user639860
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 14 2008
Added on Jun 13 2008
10 comments
859 views