Personalize label on a database view

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-22-2013 06:12 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-22-2013 07:51 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-06-2021 11:26 AM