Okay
  Public Ticket #3822013
wdt_created_by and wdt_last_edited_by
Open

Comments

  • Maciej Splisgart started the conversation

    Good day, I have a question about creating manual tables. We have the ability to edit data and in some tables the columns wdt_created_by and wdt_last_edited_by automatically appear. Now, when I want to create a new manual table, wdt_ID is automatically added. How do I force the appearance of wdt_created_by and wdt_last_edited_bywdt_created_by and wdt_last_edited_by in the manual table? Best regards

  •  1,877
    Miloš replied

    Hi Maciej,

    For our Manual table type - The columns such as "created by" and "last edited by" are created by default and they are hidden.

    The wdt_ID is also a Manual table exclusive feature.
    We add this automatically (also hidden by default) in order for the editing to work properly.
    It is an auto-increment unique integer row identifier in the SQL.

    For a custom SQL table, you will have to manually create a "column for editing" like that.



    We do not currently have any built-in solution to 'set' these hidden columns to 'always display' for Manual tables.

    You need to go in the Column list and toggle their visibility, that is the only way.



    If you wish to see a 'toggle' option to enable all these columns be visible by default, you can make a development suggestion.

    Please feel free to search on our suggestions page

     to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there,  and as more people vote, the feature will move higher on the priority list.

    You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

    and our newsletter, so you're informed about new features, bug fixes, freebies, etc.


    2. in some tables the columns wdt_created_by and wdt_last_edited_by automatically appear.


    The only way currently to have all the columns visible by default, is by calling this data via an SQL Query-based table.

    You can do this, by checking in the Manual table, in the editing options, what's the MySQL Table Name.

    Now, make a new SQL Query table like : SELECT * FROM TableName.

    This calls all columns from the source Manual table, and makes all of them visible by default - then you need to go in the Column list and toggle if some of them should be hidden.

    Of course, in the SQL Query, you can also modify to limit the columns called like :
    SELECT column1,
    Column2,
    Column3
    FROM TableName
    if you just wish to call some specific columns, etc.

    I hope that helps.

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    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