Logging Activity: Difference between revisions
Jump to navigation
Jump to search
(Created page with "nuBuilder Forte can track when records are... *Added *Accessed *Edited and by whom. This information is stored as a JSON string in a field named by joining the table name ...") |
No edit summary |
||
| (7 intermediate revisions by the same user not shown) | |||
| Line 8: | Line 8: | ||
<div style='background-color:#D8E4FF;padding:10px'> | |||
Add a varchar(1000) starting with the table's name followed by '''_nulog''', to a table and nuBuilder Forte will start automatically logging activity to each record in that table. | |||
</div> | |||
You can use a version of the SQL below to create the nulog field. | |||
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 | ALTER TABLE `aaa` ADD `aaa_nulog` VARCHAR(1000) NOT NULL | ||
Latest revision as of 20:16, 19 December 2017
nuBuilder Forte can track when records are...
- Added
- Accessed
- Edited
and by whom.
Add a varchar(1000) starting with the table's name followed by _nulog, to a table and nuBuilder Forte will start automatically 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