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: 12.1   12.2   12.3   12.4   12.5   13.0   13.1   13.2   13.3   13.4    Statistic    FMM    Blog  

Audit.FieldNameForID

Looks up the Audit cache for a field ID.

Component Version macOS Windows Linux Server iOS SDK
Audit 8.0 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "Audit.FieldNameForID"; TableName; FieldID )   More

Parameters

Parameter Description Example
TableName The table name or ID.
Can be ID of table, so we lookup name by ID.
Can be result of GetFieldName() function as we remove field name automatically.
"MyTable"
FieldID The field ID to lookup. 1

Result

Returns field name or error.

Description

Looks up the Audit cache for a field ID.
Returns empty result if not found.
Version 8.2 allows you to pass table reference by ID.

Examples

Query first field name in Kontakte:

MBS( "Audit.FieldNameForID"; "Kontakte"; 1 )

Example result: "KONTAKT_ID ABGLEICHSFELD"

See also

Release notes

Blog Entries

This function is free to use.

Created 20th January 2018, last changed 17th January 2020


Audit.FieldIDForName - Audit.GetDateAndTimeAsNumbers

💬 Ask a question or report a problem