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?
SQL Query
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.
Hi,

the default pragma returns only one item at all. So only one items will be checked.

It would be an good enhancement to have an check-all option for multiselect substitution variables
You can use an expression like default="10,20" to explicitly select department numbers 10 and 20, but there is currently no option to select all by default. I have added this to the list of enhancement requests.
© Allround Automations forums