Difference between revisions of "Logging Activity"

From nuBuilderForte
Jump to: navigation, search
 
Line 8: Line 8:
  
  
 +
<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.
 
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 04:46, 20 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