Parameter default for checkbox parameters

(2 posts) (2 voices)
  1. fdelpozo, Blocked

    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.

  2. myDBR Team, Key Master

    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


Reply

You must log in to post.