Logging Activity

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 in a field named by joining the table name with '_nulog' eg. customer_nulog

and 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