Hey there, Awesome Customers!
Just a heads up: We'll be taking a breather to celebrate International Workers' Day (May 1st and 2nd - Wednesday and Thursday) and Orthodox Easter from Good Friday (May 3rd) through Easter Monday (May 6th). So, from May 1st to May 6th, our team will be off enjoying some well-deserved downtime.
During this time, our customer support will be running on a smaller crew, but don't worry! We'll still be around to help with any urgent matters, though it might take us a bit longer than usual to get back to you.
We'll be back in action at full throttle on May 7th (Tuesday), ready to tackle your questions and requests with gusto!
In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find loads of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel). These gems might just have the answers you're looking for while we're kicking back.
Thanks a bunch for your understanding and support!
Catch you on the flip side!
Warm regards,
TMS
Hello, I have an issue with data filters, that are not working on my site even if I followed your documentation to set them.
Please see this video capture of one of my tables:
https://we.tl/t-4H8nAqcOI4
Hello Emanuele
The filters don't work because of the query.
When using the query window, make sure not to include accent graves ( ` ) around columns. Also, don't use aliases with a space in quotations.
You can add them like:
SELECT column1 AS column_1_alias
FROM table
That's it. No quotations, no accent graves, no semi-colons. You can change the displayed header later in column settings.
If you're pulling the table from an external database, you'll need to add it in wpDataTables settings/Separate DB Connection, then select that connection in the table creation menu, and then use simple query like I've shown above.
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
Unfortunately it does not seem so, I made as you suggested but still the same issue.
Look at this video https://we.tl/t-UxSrl325Ho
Thanks for the video Emanuele.
Please tell me what's this:
It seems like this is a table being pulled from a separate database? If that's true, you need to add the separate DB connection in wpDataTables settings, and then pull these columns only from the table.
If it's on the same database (WP database), you don't need the database before the table, so:
FROM wp-a_visite_referto
should be enough.
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
Great thanks, my problem was the back tick
Actually I have still the same problem here: https://we.tl/t-c4mwEw05HE
No external DB, no back ticks...
Thanks
That's strange Emanuele
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party.
You can write credentials here just check Private Reply so nobody can see them except us.
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
Hi again Emanuele
I don't know why this table is behaving like this. I created a new TEST SUPPORT table with the same query (without aliases) that works fine.
The only issue I see is that the MySQL table name for editing (in the EDITING tab above the table) is:
Instead of wpoa_terapie_a_domicilio
You may use the new table I created, as it works well. Apply the same settings, and check if the issue will come back. If it does, please try to figure out what change you made before it did.
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