Monkeybread Software - MBS FileMaker Plugin: Audit.Changed2

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

Audit.Changed2

Same as Audit.Changed, but here you pass the list of fields to check.

Component	Version	macOS	Windows	Linux	Server	FileMaker iOS SDK
Audit	3.1	Yes	Yes	Yes	Yes	Yes

MBS( "Audit.Changed2"; timestamp; TableName; FieldsToCheck ) More

Parameters

Parameter Description Example

timestamp Pass here the timestamp field you added for auditing to the table. AuditTimeStamp

TableName The name of the table.
With 10.2 optionally as second value the name of the audit log table unless you take the default AuditLog. "Firma¶MyAuditLog"

FieldsToCheck A list of field names to check. "myField"

Parameter	Description	Example
timestamp	Pass here the timestamp field you added for auditing to the table.	AuditTimeStamp
TableName	The name of the table. With 10.2 optionally as second value the name of the audit log table unless you take the default AuditLog.	"Firma¶MyAuditLog"
FieldsToCheck	A list of field names to check.	"myField"

Result

Returns 1.

Description

Same as Audit.Changed, but here you pass the list of fields to check.
With plugin version 4.4 you can use * on the end of the name to match all names starting with same text.

The Audit.Changed2 function with passing field list is quicker than the Audit.Changed function as we skip querying the field list from FileMaker.

Examples

Log record on changes:

MBS( "Audit.Changed2"; MyTable::AuditTimeStamp; "MyTable"; "firstName"; "lastName"; "age" )

Run Audit.Changed2 with list of fields in a global field in the table:

Evaluate("MBS(\"Audit.Changed2\"; GetAsTimeStamp(\"" & Events::AuditTimeStamp & "\"); \"Events\"; \"" & Substitute(Events::AuditFields; "¶"; "\"; \"") & "\")")

Run Audit with GetFieldName with v8.3 or newer:

MBS("Audit.Changed2"; // call with positive list
AuditTimeStamp; // the timestamp field to trigger this
"Audit"; // the name of table
GetFieldName ( SomeText); // the fields to check
GetFieldName ( SomeNumber);
GetFieldName ( SomeTime);
GetFieldName ( SomeTimeStamp);
GetFieldName ( SomeContainer);
"InsideScript|" & $$InsideScript) // and we pass an extra field with global variable

Example Databases

Audit/Event Management with Audit/Event Management with Audit

Blog Entries

FileMaker Magazin

Release notes

Version 10.4
- 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.
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.

Created 18th August 2014, last changed 2nd April 2020

Audit.Changed - Audit.ClearCaches

Feedback: Report problem or ask question.