kirchaj
Posts: 215
|
| Posted: 08/17/2016, 2:31 PM |
|
Has anyone implemented activity logging in a CCS application? I am not sure to what extent the customer wants to log employee activity, but I thought maybe someone had already created this for another app and could give me some ideas.
Thanks.
Tony
|
 |
 |
MichaelMcDonald
Posts: 640
|
| Posted: 08/18/2016, 3:39 AM |
|
timestamped inserts into log tables - custom code in the after insert, after udpate, and delete events
_________________
Central Coast, NSW, Australia.
|
|
|
|
eratech
Posts: 513
|
| Posted: 08/19/2016, 1:28 AM |
|
@kirchaj - I have a similar method as MichaelMcDonald. I just put a common function in so all I need to do in the After Insert etc is a Call Function and use the same function and maybe pass a flag for 'insert' or 'update'
I also use that function to set the display of a "Item as been Saved" flash-message (not 'Flash', just 'short lived message')
Eric
_________________
CCS 3/4/5 ASP Classic, VB.NET, PHP
Melbourne, Victoria, Australia |
|
|
|
ccsminer
Posts: 159
|
| Posted: 08/22/2016, 8:35 AM |
|
It's helpful to add create/update timestamp fields, as well as the active user ID, to each of the tables where logging is required. It's simple and effective, and taken care of during record inserts and updates automatically.
For more extensve auditing, use a seperate audit table to keep track of what users did and to which tables.
|
|
|
|
|
