Please note that our support refers only to wpDataTables, not SQL.
Creating a pivot table is not possible with the plugin's built-in features.
You would need to create a Pivot table in the database; then prepare a MySQL view (a stored query), which will return the data from that Pivot table, call it e.g. “view1” and then build a wpDataTable based on a simple query like “SELECT * FROM view1″.
How can I create a pivottable within an sql query?
Current data:
ID, Data A, Data B, Data C
1, 25, 30, 35
The output should be:
ID, 1
Data A, 25
Data B, 30
Data C, 35
Hello Wynand
Thank you for your purchase.
Please note that our support refers only to wpDataTables, not SQL.
Creating a pivot table is not possible with the plugin's built-in features.
You would need to create a Pivot table in the database; then prepare a MySQL view (a stored query), which will return the data from that Pivot table, call it e.g. “view1” and then build a wpDataTable based on a simple query like “SELECT * FROM view1″.
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