As previously announced via banners and our newsletters, support is no longer available through this platform.

For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.

You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.

Paid customers: Please log in to your store account for support.

Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com

Okay
  Public Ticket #2017711
Is it possible filter and transpose output?
Closed

Comments

  • Александр started the conversation

    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.

  •  2,576
    Aleksandar replied

    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 | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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