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″.
When you make table using mysql query, the table will be editable in all cases. We are not sure where you get that information.
So when you are using complicated queries our suggestion is to make a view from that table in database and use it for making wpdatatables which will return the data that you need.
Hi,
I have a query like this:
Number range filters on column 'difference' won't work, it always returns no data. Any solution to this?
actually this problem addresses all the filters, not just the number range one
Hi Johannes,
Thank you for your purchase.
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″.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Hi Milan,
I need to be able to edit the data, which I cannot do using a view and wpDataTables as far as I know, is this correct?
So using a view isn't going to do the job.
If I switch off server-side processing, the filters work fine. But since I cannot edit data then, this is not an option either.
Hi Johannes,
When you make table using mysql query, the table will be editable in all cases. We are not sure where you get that information.
So when you are using complicated queries our suggestion is to make a view from that table in database and use it for making wpdatatables which will return the data that you need.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Hi Milan,
you're right, it does work. Sorry, I don't know why I had this in mind.
Thank you
Hi Johannes,
You are welcome.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables