Hey everyone!
With the Labour Day holidays coming up, we’d like to let you know about our upcoming working hours:
Thursday, May 1st: Our team will be off during Labour Day.
Friday, May 2nd: We'll also be off for an extended holiday break.
We’ll be back on Monday, May 5th, ready to respond to all messages received during this time.
In the meantime, if you need help, feel free to:
-
Use the support widget on the bottom right of our websites (Amelia and wpDataTables) — our AI-powered assistant is available 24/7 and can help with many common questions.
-
Visit our documentation, articles, or YouTube channels for quick answers and step-by-step guides.
https://www.youtube.com/@AmeliaWordPressBookingPlugin/videos
https://www.youtube.com/@wpDataTables/videos
Thank you for being so understanding, and we hope you enjoy the long weekend!
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