Setup:
a dbjoin rendered as checkbox
filter setting of this element = dbjoin
The default order of this element (in form and in filter) is set by the xy element of the repeat table - which contains the values, not the labels.
I can order the labels in the form display by adding
order by {thistable}.xy in Data-where /"Joins where..."
But I can't manage to order the filter labels
Fabrik is running the "Filter where" at some point (it's throwing an error message if the syntax is not correct) but it ignores any ordering
"3=3 order by text" is creating the correct query (result ordered by the labels in phpMyAdmin)
a dbjoin rendered as checkbox
filter setting of this element = dbjoin
The default order of this element (in form and in filter) is set by the xy element of the repeat table - which contains the values, not the labels.
I can order the labels in the form display by adding
order by {thistable}.xy in Data-where /"Joins where..."
But I can't manage to order the filter labels
Fabrik is running the "Filter where" at some point (it's throwing an error message if the syntax is not correct) but it ignores any ordering
"3=3 order by text" is creating the correct query (result ordered by the labels in phpMyAdmin)