As previously announced via banners and our newsletters, support is no longer available through this platform.
For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.
You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.
Paid customers: Please log in to your store account for support.
Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com
I have a table with about 40k rows that I want to be able to display and sort. I'm using the server-side processing so the table loads (it doesn't load at all without this). However, now that I have this set-up, filtering no longer works as you can test on the example: http://45.55.182.44/results/. Is it possible to filter these columns? It looks like I can still filter based on URL parameters, so seems like it should be possible to do so: http://45.55.182.44/results2016/?wdt_column_filter[4]=M
Bonus question; how do I include a string with spaces in the URL parameter to filter by? I tried replacing the space with '+' without success.
http://45.55.182.44/results2016/?wdt_column_filter[0]=Archie+Post+5+Miler
Ok - found the answer to this! I had to make a view of my query, as noted in the docs.
> If your MySQL-query based wpDataTable doesn’t work correctly with server-side processing, probably this is happening because wpDataTables server has problems with parsing of the query and building new queries dynamically (happens rarely, but does sometimes). To avoid this please prepare a MySQL view (a stored query), which will return the data that you need, call it e.g. “view1” and then build a wpDataTabled based on a simple query like “SELECT * FROM view1”.
And once I've done this, filtering with URL parameters with a '+' for the space works!
Hi jstantongeddes,
Thank you for your purchase.
Sorry for delay answer we had some national holidays.
Congratulations for finding the solution for both questions.
If you have any issues feel free to ask, we will gladly help.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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