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
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.
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.
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
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 | 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