default values for multiselect substitution variables? - 02/11/19 01:24 PM
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?
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.
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?
SQL Query
select * from emp where deptno IN (&<name=''Department number'' list=''select deptno from dept order by dname'' multiselect=''yes''>)