I am hoping someone can provide some guidance; I'd like to display the column label instead of the column name as the value.
In the screenshot the field Updated Field is pulling data from another field instead of displaying the column name as in the screenshot (u_preferred_first_name), I'd like to be able to display the column label = Preferred First Name.
Any help would be much appreciated, thank you.
Hello.
Unfortunately I cannot offer a practical solution, but I can offer two methods from a technical aspect.
The first way is to add a Calculate Value Field to the sys_audit table.
Customize the sys_audit table to add a custom field (e.g. Field Label[u_field_label]) that displays the label name.
Specifically, the field label is retrieved from the sy_db_object table based on the table name and field name in the sys_audit table.
This worked as expected.
Set it up as shown in the following image.
Calculation
(function calculatedFieldValue(current) {
var gr = new GlideRecord(current.tablename);
gr.query();
return gr[current.fieldname].getLabel();
})(current);Result
The second way is to create a database view.
Create a database view (e.g., u_sys_audit_sys_dictionary) that combines the sys_audit table and sys_dictionary.
By specifying the audit_fieldname=dict_element && audit_tablename=dict_name Where clause in the view of the sys_dictionary table, the sys_audit table can display Column label together.
The configuration is shown in the following image.
Where clause
audit_fieldname=dict_element && audit_tablename=dict_name
However, customization to system tables such as the sys_audit table should be cautious in terms of impact on OOTB functionality and instance performance.
Perhaps these methods are generally not recommended.
If you have other expert opinions, please let me know.
