This time a table doesn't except this SQL. And it did! At some point this table was working fine.
SELECT gatunek, liczba_w, liczba_s, liczba_p FROM viewDaneZwierzetaTypy WHERE rok = 2018 ORDER BY FIELD(gatunek,'lis','zając szarak','jeleń szlachetny','sarna','dzik','bażant','gęsi','kaczki','inne')
Now I am getting error as in attached screenshot1. It also doesn't allow me to specify COLLATION. I'm getting another error, screenshot2.
And another problem :)
This time a table doesn't except this SQL. And it did! At some point this table was working fine.
SELECT
gatunek,
liczba_w,
liczba_s,
liczba_p
FROM
viewDaneZwierzetaTypy
WHERE
rok = 2018
ORDER BY
FIELD(gatunek,'lis','zając szarak','jeleń szlachetny','sarna','dzik','bażant','gęsi','kaczki','inne')
Now I am getting error as in attached screenshot1. It also doesn't allow me to specify COLLATION. I'm getting another error, screenshot2.
Hello again Przemyslaw
I am afraid that this would, again, require creating a view from this view in order to work.
You can, of course, try removing the accent graves ( ` ) first, and see if it's going to work like that.
Also, you don't have to use ORDER BY - you can do it from the plugin itself.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables