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.1   9.2   9.3   9.4   9.5   10.0   10.1   10.2   10.3   10.4    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.3
    • Added Audit.GetIgnoreRepetitions and Audit.SetIgnoreRepetitions functions.
    • Added support for non global repeating fields to Audit functions.
    • Removed older code paths for Audit functions for FileMaker 10 and older. Now FileMaker 11 is minimum.
    • Rewrote Audit functions to use SQL parameters, so we can log emojis and avoid SQL injections.
  • 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 Xojo Chart Plugins