Multiple selection in list

[hsshah]

Is it possible to allow the user to have multiple selection while using 'list'?

For e.g.
Select department, sum(emails)
from email_volumes
where department IN (&)

The functionality what I am looking for is similar to HTML drop box that allows multiple selection.

Any help will be appreciated.

 

[Marco Kalter]

This is currently not possible. It would require a "multi-select" list. The only alternative I can think of is to use an untyped variable where the user can enter all department names in quotes, separated by commas.

 

[ERICHO]

You can try check box option. Restriction is you must amend sql statement after any department changes.