How to create MySQL View and use JOIN in wpDataTables plugin
ฝัง
- เผยแพร่เมื่อ 28 ธ.ค. 2024
- In this video we will show you how you can use MySQL views to display the data using our plugin. If you have some more complexed queries,
then creating view can do the trick in order to properly work with sorting
and filtering through wpDataTables.
Try wpDataTables free plugin on
WordPress.org: wordpress.org/...
Buy wpDataTables Plugin: wpdatatables.c...
Handy guide, thank you! Would be great if you could also do some examples with tables based on popular plugins like ACF, Woo, form builders. I’m sure many people would like to know how to do these!
Thank you for your feedback, Alexander. We have a plan to record more videos for this topic, so stay tuned!
Thanks in the past i opened a ticket about this.
Hi Massimiliano,
Sorry for taking us this long to record this video, but we hope that now it can help you out for creating complex queries and MySQL views.
Best
@@wpDataTables yes It Is very usefull
Great video, guys! Keep it going 🙌
Thank you so much!!!
Great video. Is this SQL functionality new? I'm not sure I could do this two years ago?
-- also Is is possible to connect "Button" to build the select statement, to populate your wpDataTables. (Or do the sql queries need to be static?)
Again, Great tutorial!!! thanks!
Hi Larry,
This is not new functionality, we just tried to make it easier for our users which have complex queries to show how they can create MySQL view and use it within our plugin.
As for your question can you please describe to us more what are you trying to achieve because we did not quite understand?
Thank you.
Is it possible to automatically read the MySql database to automatically update an existing graph so that this happens every 1 to 2 hours, for example?
Disabling Server-side processing filters data the way you want it even complex queries. Creation of View query is also not required from my end for filtering the data.
Hi, Ronit
Apologies for commenting on your reply after all this time.
Just to follow up,
you are absolutely correct, some of our SQL Parser limitations can be avoided by disabling server-side processing,
but that can be done only if you have a "smaller" data set, less than 2 or 3 thousand rows.
For larger data sets, the server-side processing is automatically enabled and can not be disabled,
because very large tables can become very slow and even break the page - so server-side is useful in terms of limiting the number of rows that are loaded at a time, by using AJAX calls.
hi I created 2 tabs in the browser and tried to put a table on the frontend on tab 1 and tab 2 on the backend I tried to input data but on the frontend the data did not display new data, I also created a view and checked serverside but it doesn't work, is this a bug
Hi Swis,
Thank you for your inquire.
This should not be the issue. Can you please open a support ticket for this case and our agents will help you out?
tmsplugins.ticksy.com/submit/#100010481
Best regards.
Hi Team,
Seems like the text query filter only works with server side processing Checkbox and selectbox features are still not working properly with server side processing. It would be very helpful if your team resolves this issue soon. Anyways heartfelt thanks for wpDataTables wonderful features.
Hi aaryan sudhan
Thank you for your inquire.
Probably some settings are not configured correctly for that select box, did you choose to display all of the data for specific select box?
The best solution for this case is to contact our support team and they will resolve this issue for you.
Feel free to open a ticket tmsplugins.ticksy.com/submit/#100004195
Best regards.
@@wpDataTables Thanks for your valuable reply . The issue got resolved with custom value list.
@@wpDataTables Missing one functionality "Unable to export all results to Excel , Particular page results are only being exported " Is there any workaround here if it's there please help me to solve this issue struggling for a long time your valuable help matters a lot to me Thanks.
@@aaryansudhan8138 For tables with server-side processing, only the visible rows will be exported to any format. If you want the entire table to be exported (or copied to a clipboard), you need to choose the “Show All” feature in the “show … entries” block, and then do the export
Best regards.
I created a view to try and solve the filtering problem, still doesn't work. The View works fine. Filtering doesn't.
Trying to remove the ` ` around the View name in the SELECT call results in a resource forbidden error.