Topics   All   MacOS (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Guides   Examples
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.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.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

25 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
  • Version 8.0
  • Version 7.3
  • Version 7.2
  • Version 7.1

Blog Entries

Example Databases

Feedback: Report problem or ask question.




Links
MBS FileMaker Plugins