Okay
  Public Ticket #2361711
Managing Large Number of Tables/Charts
Closed

Comments

  • Greg started the conversation

    We are planning on having a large number of tables and charts - each that have different categories.

    A couple of questions:

    Is it possible to add a "date created" column or sort by date created on the backend of the list of tables and charts?

    Can tables and charts be tagged with categories or grouped together to be easily found in the list of tables and charts?

  •  2,507
    Aleksandar replied

    Hello Greg

    I am sorry to disappoint you, but unfortunately this is not implemented in the plugin's built in features. However, there is a workaround for this.

    For example, I created a simple manual table:

    9084543304.png

    wdt_ID column is being automatically generated, and is usually hidden, but I've displayed it here for explanation purposes.

    When I created a table, and added the first row, I could then modify it. So, in order to set the Datetime column to be auto-populated, I had to open the table in the database. It is being stored as wp_wpdatatable_6, and you can see its database name in Editing tab in the settings above the table:

    8975736742.png

    Then, in PHPMyAdmin, I opened the table, and ran the following query:

    ALTER TABLE `wp_wpdatatable_6` CHANGE COLUMN `datetime` `datetime` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP;
    
    7657773118.png

    After that, again in the Editing tab, above the table, I changed the "ID column for editing" from "wdt_ID" to "datetime" (as you can see in the screenshot above). Then I disabled editing for "wdt_ID" in the column settings:

    4393899573.png

    datetime column, being the "ID column for editing" automatically cannot be edited, but is automatically filled.

    You can also choose to hide it from view if you'd like.

    I hope this helps.

    As for the second question, I'm afraid something like this can't be done.

    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

  • Greg replied

    Hi Aleksander, I think maybe the request wasn't totally clear.

    I am look for a way to add the date created column to the list of all of my tables.

    We will have 50-100 tables and need to be able to easily sort by date created to see the most recent as well as the oldest.

  •  2,507
    Aleksandar replied

    Oh, I see Greg

    I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.

    I don't believe that this could be added as a custom solution either, since it would require changing the code of the plugin.

    Please visit our Suggest a feature page, and leave that as a feature suggestion, so our developers see that it's a requested feature.

    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