Is there a way to define default values for multiselect substitution variables?
So e.g. in the following query all entries for deptno are unchecked by default, how can flip the logic, i.e. to have all of them checked?
select * from emp
where deptno IN (&<name=''Department number''
list=''select deptno from dept order by dname''
multiselect=''yes''>)
and then the user should be able to uncheck only the entries which he needs. Question arised when I have a long list of entries which need everyt time to individually check / uncheck.