How can I add a default parameter query for a checkbox parameter?
My checkbox parameter is:
select id,name from table t where t.status='N' order by name
I need that all the check options be checked by default.
How can I add a default parameter query for a checkbox parameter?
My checkbox parameter is:
select id,name from table t where t.status='N' order by name
I need that all the check options be checked by default.
Define a default as a comma-separated list of id's. Easiest way to do this is:
1.
select
group_concat( t.id )
from
table
t
where
t.status=
'N'
--
myDBR Team
You must log in to post.