| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
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.
| Version | macOS | Windows | Linux | Server | iOS SDK |
| 2.8 / 13.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
| Item | Details |
|---|---|
| Audit.Backup Log record. | All 8.5 |
| Audit.Backup2 Log record. | All 8.5 |
| Audit.BaseTableNameForID Looks up the Audit cache for the base table name for a given table occurrence ID. | All 13.1 |
| 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.GetDateAndTimeAsNumbers Queries state for this option. | All 12.3 |
| 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.Hash Hashes the field/value. | All 11.1 |
| Audit.SetDateAndTimeAsNumbers Sets whether time values are stored as numbers. | All 12.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.Statistics Queries statistics for Audit functions. | All 12.1 |
| Audit.TableIDForName Looks up the Audit cache for a table name. | All 8.2 |
| Audit.TableNameForID Looks up the Audit cache for the table name for a given table occurrence ID. | All 8.0 |
32 functions shown.
9 functions require a license (28%) and 23 functions are free to use.
Release notes
- Version 13.3
- Changed Audit functions to return SQL errors from Insert, so you may debug when something goes wrong.
- Version 13.2
- Changed Audit.Delete and Audit.Delete2 to record new fields found before deleting with Delete instead of Create.
- Version 13.1
- Added Audit.BaseTableNameForID function.
- Version 12.3
- Added Audit.GetDateAndTimeAsNumbers and Audit.SetDateAndTimeAsNumbers to log dates, times and timestamps as numbers instead of text.
- Version 12.2
- Added SchemaCacheFlushed counter for Audit.Statistics function to show how often we flushed the table cache.
- Version 12.1
- Added Audit.Statistics function.
- Fixed bugs in Audit.Changed when using repetition fields.
- Version 12.0
- Fixed handling of PageNumber field for Audit.Changed functions.
- Version 10.4
- Changed Audit.SetIgnoreSummaryFields and Audit.SetIgnoreCalculations to clear field cache, so the setting is applied sooner.
- Fixed a crash in Audit functions when querying GetFieldID internally. Affects Audit.Backup, Audit.Backup2, Audit.Changed, Audit.Changed2, Audit.Delete and Audit.Delete2 functions.
- Fixed an issue where Audit.Changed would rebuild the table cache too often.
- Improved Audit.Changed and related to only query table list once per call.
- 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.
Blog Entries
- MBS Plugin 13.3 for Claris FileMaker
- Thoughts about OnWindowTransaction
- MBS FileMaker Plugin, version 13.3pr1
- Configure Audit functions in MBS Plugin
- New in MBS FileMaker Plugin 12.1
- MBS FileMaker Plugin 12.1 - More than 6700 Functions In One Plugin
- MBS FileMaker Plugin, June 2021 News
- MBS FileMaker Plugin 10.4 - More than 6300 Functions In One Plugin
- Perform Script on Server with Audit for FileMaker Go
- MBS FileMaker Plugin 10.3 - More than 6200 Functions In One Plugin
FileMaker Magazin
Example Databases
