I found this thread: http://fabrikar.com/forums/index.php?threads/multi-select-filter-values-a-to-z.50471/#post-263710 and this article in the wiki: http://fabrikar.com/forums/index.php?wiki/database-join-element/#data-where both of which suggest I should be able to override the filter's default sorting to use the parent table--the one with words that can be sorted A-Z rather than the repeat table holding the multiselect info.
Two tables: intepreters and interpreter_lang. The 'Language' element in interpreters is a db join to the id column of the interpreter_lang table with the value being the id and the label the language name. The join is a multi select and so that is saved in the interpreters_repeat_Language table. I can't get the filter to sort alphabetically by interpreter_lang.language.
I've added: 1 = 1 ORDER BY `interpreter_lang`.`language` to the "filter where' field and I don't get any errors, HOWEVER, also the thing is not sorted by language. It's sorting by `interpreters_repeat_Language`.`Language` which is an id so basically it's a scrambled list of languages.
Many thanks in advance for any assistance with this.
Regards,
Kelly
Two tables: intepreters and interpreter_lang. The 'Language' element in interpreters is a db join to the id column of the interpreter_lang table with the value being the id and the label the language name. The join is a multi select and so that is saved in the interpreters_repeat_Language table. I can't get the filter to sort alphabetically by interpreter_lang.language.
I've added: 1 = 1 ORDER BY `interpreter_lang`.`language` to the "filter where' field and I don't get any errors, HOWEVER, also the thing is not sorted by language. It's sorting by `interpreters_repeat_Language`.`Language` which is an id so basically it's a scrambled list of languages.
Many thanks in advance for any assistance with this.
Regards,
Kelly