1. Fabrik 3.9 has been released. If you have updated Joomla to 3.9, this is a required update.
    Dismiss Notice

selecting default selection(s) on a databasejoin multiselect element

Discussion in 'Professional Support' started by skyrun, Jan 1, 2020.

  1. skyrun

    skyrun Active Member

    Level: Professional
    can this be done either using the 'default' on the main options tab or eval options on the advanced tab?

    note that i'm using enhanced dropdowns and have only tested with that set to 'yes'.

    what i tried:
    • using default on options tab: tried putting in multiple values for default like 1,2,3,4,5,10 and the json {1,2,3,4,5} and tried a single value like '1'. these are values that are on the list, but that didn't work. i figured at least putting in just a '1' would select that one option, but it didn't.
    • looks like the eval options allow changing value and label (text) but can't set 'selected'.
    another note, if you specify 'order by' in data where to attempt to change the order of the selections in an enhanced dropdown from the default which is alphabetically, it reverts the list to a std dropdown. perhaps necessesary for how the jquery library being used works, but would be nice to be able to sort those options.
     
  2. troester

    troester Well-Known Member Staff Member

    Level: Community
    [1,2,10]
    or
    [1]
    should do.

    ORDER BY text DESC (literally text, eg. if you have concat labels)
    ORDER BY field DESC (column name)
    ORDER BY id DESC

    is working on my site.
     
    Last edited: Jan 3, 2020

Share This Page