Logging Activity: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 9: | Line 9: | ||
Simply add a varchar(1000) starting with the table's name followed by '''_nulog''', to a table and nuBuilder Forte will start logging activity to each record in that table. | Simply add a varchar(1000) starting with the table's name followed by '''_nulog''', to a table and nuBuilder Forte will start logging activity to each record in that table. | ||
This information is stored as a JSON string | This information is stored as a JSON string and when formatted, looks like this. | ||
{ | { | ||
Revision as of 20:07, 19 December 2017
nuBuilder Forte can track when records are...
- Added
- Accessed
- Edited
and by whom.
Simply add a varchar(1000) starting with the table's name followed by _nulog, to a table and nuBuilder Forte will start logging activity to each record in that table.
This information is stored as a JSON string and when formatted, looks like this.
{
"added": {
"user": "globeadmin",
"time": 1513706208
},
"viewed": {
"user": "globeadmin",
"time": 1513706382
},
"edited": {
"user": "globeadmin",
"time": 1513706382
}
}
You can use a version of the SQL below to create the nulog field (change aaa to your table name).
ALTER TABLE `aaa` ADD `aaa_nulog` VARCHAR(1000) NOT NULL