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

Ordering the filter on a list view of a db join multiselect element

Discussion in 'Community' started by usdc-or, Jul 12, 2019.

  1. usdc-or

    usdc-or Member

    Level: Community
    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.


Share This Page