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:
select group_concat( t.id ) from table t where t.status='N'
--
myDBR Team
You must log in to post.