| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
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
- Version 8.2
- Changed Audit.FieldNameForID to accept table ID or name.
- Version 8.0
- Added Audit.FieldNameForID and Audit.TableNameForID.
Blog Entries
This function is free to use.
Created 20th January 2018, last changed 17th January 2020
