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 #2534559
SQL Table losing conditional formatting
Closed

Comments

  •  2
    Marian Harris started the conversation
    September 10, 2020 at 2:38am

    Hi,

    I've made a wpdt table that has 2 columns, which it gets from an SQL table of about 100 columns by this query: 

    SELECT `ABC University`,

            `IconColumnText`

    FROM  UniInfoTable

    WHERE  `ABC University` <>"x";

    When I duplicate the wpdt table, and change the duplicated-table's query so that one of the columns it selects is different from the original query, like this:

    SELECT `XYZ University`,

            `IconColumnText`

    FROM  UniInfoTable

    WHERE  `XYZ University` <>"x";


    then I lose all the conditional formatting in the changed column.

    Is there a remedy for this?

    Thank you.

    Marian




  •  2,576
    Aleksandar replied
    September 10, 2020 at 8:13pm

    Hello Marian

    Conditional formatting is one of the settings, that are saved in the database tables wp_wpdatatables_columns and wp_wpdatatables. Since SQL query tables are basically tables linked to an existing data source, the data of a conditional format is added in those tables, and it depends on column headers.

    When the database header is modified in the description of the table, the conditional formatting is reset, so you will need to do it again, unfortunately, or if you know your way around SQL, you can copy it from the other table, and just change the column header.

    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