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.3
9.4
9.5
10.0
10.1
10.2
10.3
10.4
10.5
10.6
Statistic
FMM
Blog
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.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.
- 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
- Neues MBS FileMaker Plugin 10.4
- MBS FileMaker Plugin 10.4 - More than 6300 Functions In One Plugin
- Perform Script on Server with Audit for FileMaker Go
- MBS FileMaker Plugin, version 10.4pr1
- Neues MBS FileMaker Plugin 10.3 - Über 6200 Funktionen in einem Plugin
- MBS FileMaker Plugin 10.3 - More than 6200 Functions In One Plugin
- MBS FileMaker Plugin, version 10.3pr4
- MBS FileMaker Plugin, version 10.3pr1
- MBS FileMaker Plugin, version 10.2pr6
- MBS FileMaker Plugin, version 10.2pr4
Example Databases
Feedback: Report problem or ask question.
Links
MBS Xojo Chart Plugins
