Logging Activity: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
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. | 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. | This information is stored as a JSON string and when formatted, looks like this. |
Revision as of 20:08, 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