with wpdatatables I created a table from SQL-query. This table contains two columns (Durchmesser and Temperatur). I wanted to filter the "Durchmesser" column to see the analogue "Temperatur"-value.
The data-format in MySql for "Temperatur" is int and the data-format for "Durchmesser" is float. I tried every filter setup, but it doesn't show any filtered result.
If you have accent graves ( ` ) around column names, that could cause this issue. Also, if you're calling the table from a separate database through the query, that could cause this issue. If you have added a semi-colon ( ; ) at the end of the query, that too can cause this issue.
Please try to remove these, and let me know if that helps.
If it doesn't help, then please just show me the query, so I can see what's wrong.
Hello,
with wpdatatables I created a table from SQL-query. This table contains two columns (Durchmesser and Temperatur). I wanted to filter the "Durchmesser" column to see the analogue "Temperatur"-value.
The data-format in MySql for "Temperatur" is int and the data-format for "Durchmesser" is float. I tried every filter setup, but it doesn't show any filtered result.
Best regards,
Florian
Hello Florian
Thank you for your purchase.
How does that query look like?
If you have accent graves ( ` ) around column names, that could cause this issue. Also, if you're calling the table from a separate database through the query, that could cause this issue. If you have added a semi-colon ( ; ) at the end of the query, that too can cause this issue.
Please try to remove these, and let me know if that helps.
If it doesn't help, then please just show me the query, so I can see what's wrong.
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
Hello Aleksandar,
-solved-
The query was the problem I renamed the columns with an 'as' statement. This caused the problem.
Thank you very much for your tip.
Best regards,
Florian
Great news, Florian
Thanks for letting me know.
If I'm not mistaken, that's a separate DB you've been using, right?
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