Personalize label on a database view

amadosierra
Kilo Guru

I have created a database view that joins data from multiple tables where some of the field names are the same among these tables. In the list or form view there is no way of knowing where the value is coming from.
It seems there is no way of personalizing the label, like in a regular form (not a database view). Does anybody know if it's possible to change the label of the field in a database view?

Thanks for your help.

/Amado

2 REPLIES 2

CapaJC
ServiceNow Employee
ServiceNow Employee

There's no easy way through the UI, but here's what I tried that seemed to work as a proof of concept.

I went to System Definition > Language File, and created a new record. For table, I used the database view name. In my case, incident_sla. Then for the element value, I used the column name used by the database view. So for the Number field of the Incident table, since the prefix for the Incident table in the database view is "inc", I used "inc_number" as the element value. Then I gave it a label of "Incident Number", saved it, and when I went back to the database view the label for Number had changed to Incident Number.


Hello, 

 

I attempted to do this and my database view in reporting is not showing the updated label. Am I doing something wrong?


Thank you, 

Bridgette Weirich