Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   Crossplatform   Server (Not)   Client   Components   Old   Guides
New in version: 4.0   4.1   4.2   4.3   4.4   5.0   5.1   5.2   5.3   5.4   6.0   6.1   6.2   6.3   6.4   6.5   7.0    Statistic  

Audit.Changed2

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

Component: Audit
Version: 3.1
Mac OS X: Yes
Windows: Yes
Server: Yes
FileMaker Cloud: Yes

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

Parameters

Parameter Description Example value
timestamp Pass here the timestamp field you added for auditing to the table. AuditTimeStamp
TableName The name of the table. "Firma"
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.

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; "¶"; "\"; \"") & "\")")

See also


Audit.Changed   -   Audit.ClearCaches

Feedback: Report problem or ask question.




Links
MBS Real Studio PDF Plugins - Nachhilfe in Kruft