Monkeybread Software - MBS FileMaker Plugin: Component: Audit

Topics All MacOS (Only) Windows (Only) Linux (Only, Not) iOS (Only, Not)
Components Crossplatform Mac & Win Server Client Old Deprecated Guides Examples
Videos
New in version: 9.0 9.1 9.2 9.3 9.4 9.5 10.0 10.1 10.2 10.3 Statistic

Component: Audit

Log all changes to your database.

For FileMaker Pro.
We define fields in each table which trigger our Audit function, so with any change in a record, the plugin can keep track of changes.

Item	Details
Audit.Backup Log record.	All 8.5
Audit.Backup2 Log record.	All 8.5
Audit.Changed Log record change.	All 2.8
Audit.Changed2 Same as Audit.Changed, but here you pass the list of fields to check.	All 3.1
Audit.ClearCaches Clears internal caches for audit functions.	All 3.1
Audit.Delete Log record deletion.	All 2.8
Audit.Delete2 Same as Audit.Delete, but here you pass the list of fields to check.	All 3.1
Audit.FieldIDForName Looks up the Audit cache for a field name.	All 8.2
Audit.FieldNameForID Looks up the Audit cache for a field ID.	All 8.0
Audit.GetEnabled Queries enable status.	All 7.1
Audit.GetIgnoreCalculations Queries whether stored calculations are audited.	All 4.4
Audit.GetIgnoreRepetitions Queries whether repetition fields should be ignored.	All 10.3
Audit.GetIgnoreSummaryFields Queries whether summary fields are audited.	All 5.4
Audit.GetIgnoreUnderscoreFieldNames Queries the state of the underscore ignore setting.	All 5.3
Audit.GetIgnoredFieldNames Queries list of ignored field names.	All 7.3
Audit.GetLogAccess Queries whether plugin logs access.	All 4.1
Audit.GetUUIDField Queries UUID field name.	All 7.3
Audit.SetEnabled Turns audit globally on or off.	All 7.1
Audit.SetIgnoreCalculations Set whether stored calculations are audited.	All 4.4
Audit.SetIgnoreRepetitions Whether to ignore repetitions.	All 10.3
Audit.SetIgnoreSummaryFields Set whether summary fields are audited.	All 5.4
Audit.SetIgnoreUnderscoreFieldNames Sets whether to ignore all field names whose name starts with underscore character.	All 5.3
Audit.SetIgnoredFieldNames Sets the ignored field names.	All 2.8
Audit.SetLogAccess Sets whether access is logged.	All 4.1
Audit.SetUUIDField Sets the UUID field name.	All 7.3
Audit.TableIDForName Looks up the Audit cache for a table name.	All 8.2
Audit.TableNameForID Looks up the Audit cache for a table ID.	All 8.0

27 functions.

Release notes

Version 10.2
- For Audit.Changed and Audit.Changed2 you can now customize AuditLog table name. The table name parameter can be a list and include first the table name for the table to check and second the name of the audit table name. If second is empty, we default to AuditLog.
Version 10.1
- Changed Audit.Changed and related to work with PageNumber and LayoutNumber as numeric fields.
Version 8.5
- Added Audit.Backup and Audit.Backup2 to add data to audit log without editing.
- Changed Audit functions to query field names in AuditLog table by SQL instead of looking for an AuditLog layout. The AuditLog layout is now optional and can be renamed.
- Changed Audit functions, so FieldHash is optional now if you have FieldValue. FieldID can be used if you have no FieldName.
- Improved Audit.Changed and related to set last error for SQL calls.
Version 8.3
- Improved Audit functions, so you can pass now field names with table prefix and we remove table prefix, so you can use GetFieldName() function there.
Version 8.2
- Added Audit.TableIDForName and Audit.FieldIDForName.
- Changed Audit.FieldNameForID to accept table ID or name.
Version 8.0
- Added Audit.FieldNameForID and Audit.TableNameForID.
Version 7.3
- Added UUID mode for Audit. Call Audit.SetUUIDField please to enable.
- Changed Audit.SetIgnoredFieldNames to accept list of field names.
Version 7.2
- Fixed crash in Audit.ClearCaches.
Version 7.1
- Added Audit.GetEnabled and Audit.SetEnabled.

Blog Entries

Example Databases

Feedback: Report problem or ask question.