Print Thread
default values for multiselect substitution variables?
#59582 02/11/19 01:24 PM
Joined: Sep 2015
Posts: 29
K
kirilb Offline OP
Member
OP Offline
Member
K
Joined: Sep 2015
Posts: 29
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.

Last edited by kirilb; 02/11/19 01:49 PM.
Re: default values for multiselect substitution variables?
kirilb #59583 02/11/19 03:37 PM
Joined: Mar 2007
Posts: 210
Rostock, Germany
Member
Offline
Member
Joined: Mar 2007
Posts: 210
Rostock, Germany
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


There is no shortcut for experience(d).

PL/SQL Developer Version 10+11+12, Query Reporter Version 3.2.0.300
Oracle 11g,12c
Windows Server 2003/2008
Windows 10 Professionel 64 bit



Re: default values for multiselect substitution variables?
kirilb #59584 02/11/19 03:39 PM
Joined: Aug 1999
Posts: 22,216
Member
Offline
Member
Joined: Aug 1999
Posts: 22,216
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.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.036s Queries: 15 (0.009s) Memory: 2.5036 MB (Peak: 3.0395 MB) Data Comp: Off Server Time: 2024-05-10 12:30:06 UTC
Valid HTML 5 and Valid CSS