dimoss
Well-Known Member
Hi,
I am using Gamma 3 / J!4.2.9.
I have an issue on a DB join element in a MySQL view which i use it as a dropdown filter wuth the following settings:
I used none because I want the filter to show the options in descending rder based on the clause I have in the DB Join element:
The error I get when the list loads is:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}.tournament_id DESC' at line 3
I can't understand why I get this error in order to fix it.
Any help is appreciated.
P.S. If I change the order by to 'Label' or 'Value' works but it overrides the code i have.
I am using Gamma 3 / J!4.2.9.
I have an issue on a DB join element in a MySQL view which i use it as a dropdown filter wuth the following settings:
I used none because I want the filter to show the options in descending rder based on the clause I have in the DB Join element:
Code:
ORDER BY {thistable}.tournament_id DESC
The error I get when the list loads is:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}.tournament_id DESC' at line 3
I can't understand why I get this error in order to fix it.
Any help is appreciated.
P.S. If I change the order by to 'Label' or 'Value' works but it overrides the code i have.