Topics
All
Mac OS X
(Only)
Windows
(Only)
Linux
(Only, Not)
iOS
(Only, Not)
Components
Crossplatform Mac & Win
Server
Client
Old
Guides
Examples
New in version:
8.5
9.0
9.1
9.2
9.3
9.4
9.5
10.0
10.1
10.2
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.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.
Feedback: Report problem or ask question.
Links
MBS Xojo blog
