Logging Activity: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
(One intermediate revision by the same user not shown) | |||
Line 8: | Line 8: | ||
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. | <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> | |||
This information is stored as a JSON string and when formatted, looks like this. | This information is stored as a JSON string and when formatted, looks like this. |
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