selecting default selection(s) on a databasejoin multiselect element

[skyrun]

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.

 

[troester]

[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.