Article Details
Id:13932
Product:finPOWER Connect
Type:NEW
Version:3.00.01
Opened:16/06/2016
Closed:08/07/2016
Released:10/08/2016
Job: J017599

Auditing; new function so scripts can add audit records against Accounts, Clients etc.

A new auditing function has been added to the finPOWER Connect Business Layer to allow scripts to add audit records against Accounts, Clients etc. These then appear in the Audit page of the record.

Note, Audit records are stored in the ISAudit table with the Action type noted as "User".

To add Audit records use the finBL.AuditFunctions.AuditAdd function, passing in the following parameters:

  • SourceType. This is an enum isefinAuditSourceType. It is written to the 'SourceId' field in the ISAudit table.
  • SourcePk. The primary key of the Source being audited, e.g. the primary key of an Account. This is written to the 'SourcePk' field in the ISAudit table.
  • Key. A Key detailing the process involved when creating the Audit. This is mandatory.
  • SubKey. An optional Sub-Key.
  • kvlOriginal. The Key/Value List detailing the Original values to audit.
  • kvlNew. The Key/Value List detailing the New values to audit.
  • kvlNotes. The Key/Value List detailing more information regarding the audit. This is written to the 'Notes' field in the ISAudit table.

You should be careful not to unnecessarily add auditing records.