For running J!5.1 you must https://fabrikar.com/forums/index.php?wiki/update-from-github/ or include the new file manually https://fabrikar.com/forums/index.php?threads/joomla-5-1-and-fabrik-cannot-find-files-error.54473/post-285151 See also Announcements
Please see our announcement here.
1 = 1 ORDER BY {thistable}.auteuruitlijst ASC
What are your dbjoins's Details/Data setting?
Which table column is "Auteur" linked to, which data does it contain (in the database).
There is a table "auteurs" (authors) and a table "auteursuitlijst" (authors from list). In the form "Boeken" (Books) there is an option to add one or more authors from a list.
Enable FabrikDebug in Fabrik Options and append &fabrikdebug=1 to your list URL. This will show you somewhere the generated filter query.
It must go into "Filter Where" (further down in the "Data - Where" tab).
See the tooltip there (also here attached): the WHERE is already there, so to speak, and must not be used, so your code there must look like
with "1 = 1" being the WHERE which is always true.Code:1 = 1 ORDER BY {thistable}.auteuruitlijst ASC
Hmm, sorry.Thanks, but this did not help.
And that works? Because in "Joins where..." the WHERE would be required for a condition (as opposed to the "Filter - where" field, which does not allow the WHERE but only the conditional expression), and that means it should be only "ORDER BY `text` ASC" in "Joins where...".... I use "1=1 ORDER BY `text` ASC"
View attachment 20321
@lousyfool :
You can omit the WHERE in Joins where... (it's then added by Fabrik) and so 1=1 won't hurt here.
But you must not use WHERE in Filter where...
@pwouda
You are using a multiselect dbjoin. This will create a child 'repeat' table and so the dbjoin column in your main table is empty (that's why I asked about your settings). So it seems Value/Label settings in the Element/ListView are not working in this case.
By using 'text' Fabrik will do some 'fetch label from repeat table' for you.