Logging Activity: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
(6 intermediate revisions by the same user not shown) | |||
Line 7: | Line 7: | ||
and by whom. | and by whom. | ||
<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> | |||
and looks like this | |||
This information is stored as a JSON string and when formatted, looks like this. | |||
{ | { | ||
Line 20: | Line 22: | ||
"viewed": { | "viewed": { | ||
"user": "globeadmin", | "user": "globeadmin", | ||
"time": | "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). | 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