In one of my open tickets, it was mentioned not to use the MYSQL functions like sort, etc. since WPDATA has its own.
Does this also mean SUM? I can get the Grand Total, but nothing from SQL works to insert subtotals. Tried ROLLUP in GROUP BY which did not work and when you do use SUM(), the Grand Total turns off.
Does WPDATA support subtotaling? I want to subtotal on one field of three in each row, I group by, but nothing works to insert a row for sub total for all of the distinct values of that field.
Read the documentation, there was nothing but the SUM function inherit to give a Grand Total.
Like I explain you there. 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″.
In one of my open tickets, it was mentioned not to use the MYSQL functions like sort, etc. since WPDATA has its own.
Does this also mean SUM? I can get the Grand Total, but nothing from SQL works to insert subtotals. Tried ROLLUP in GROUP BY which did not work and when you do use SUM(), the Grand Total turns off.
Does WPDATA support subtotaling? I want to subtotal on one field of three in each row, I group by, but nothing works to insert a row for sub total for all of the distinct values of that field.
Read the documentation, there was nothing but the SUM function inherit to give a Grand Total.
Hi Alan,
Thank you for your purchase.
Like I explain you there. 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 Alan,
We already answer you there so I will close this one.
BEst regards.
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