We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

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

Comments

  • Александр started the conversation
    May 20, 2019 at 2:44pm

    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
    May 21, 2019 at 10:29am

    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