Hi, I need the set of user interface functions for table output and I hope to implement it with wpDataTables. Namely, I have veeery big table (100+ lines and 80+columns). I need to give a user opportunity to set filter so as he can get on the page a) the first column (legend No1, e.g. list of geographical areas) and one of data columns of table; b) the header (legent No2, e.g. list of parameters for every area) and one of data lines of table, i.e. all parameters' values for one certain area. In this case, because line would be soooo long I probably need to transpose this table, i.e. show it as columns rather than as lines. Is this achiveable by wpDataTables? Will I need to buy some addons for it? Thanks on advance.
The size of the table isn't an issue here, since our plugin can support even millions of records when you use SQL query based tables.
I'm not sure if you're trying to apply cascade filtering, so each new filter would be dependent on the previous one? If so, you will need Powerful Filters add-on. Please take a look at the documentation and see if that's a feature you might need.
b) to do this, I believe the best way to go would be to create a Pivot table in your database, and then make a MySQL view to display it in our plugin.
Hi,
I need the set of user interface functions for table output and I hope to implement it with wpDataTables.
Namely, I have veeery big table (100+ lines and 80+columns). I need to give a user opportunity to set filter so as he can get on the page
a) the first column (legend No1, e.g. list of geographical areas) and one of data columns of table;
b) the header (legent No2, e.g. list of parameters for every area) and one of data lines of table, i.e. all parameters' values for one certain area. In this case, because line would be soooo long I probably need to transpose this table, i.e. show it as columns rather than as lines.
Is this achiveable by wpDataTables? Will I need to buy some addons for it?
Thanks on advance.
Hello Александр.
Thank you for your interest in our plugin.
The size of the table isn't an issue here, since our plugin can support even millions of records when you use SQL query based tables.
I'm not sure if you're trying to apply cascade filtering, so each new filter would be dependent on the previous one? If so, you will need Powerful Filters add-on. Please take a look at the documentation and see if that's a feature you might need.
b) to do this, I believe the best way to go would be to create a Pivot table in your database, and then make a MySQL view to display it in our plugin.
Best regards.
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