Logging Activity

From nuBuilderForte
Revision as of 19:16, 19 December 2017 by Admin (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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