Change Label name issue in Report (Database View)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-11-2014 05:16 AM
Hi Everyone,
I am working on report and the reports are created through database view.
Tables are: 1) cmdb_rel_ci and 2) u_system_tracking_report
I want to change the label name of "sys_created_on" to "Report date"and as well as "Parent" to "Application name".
When i want to change the label name through sys_documentation table then i am able to rename of u_system_tracking_report table but i m facing issue in field which are coming in report through Dot Walkin. for e.g : parent.name. Parent.created etc Please see the screenshot.
I want to change the label name in Yellow color.
Is there any way to change the label name of dot-walkin field which is coming in report. Any help will be more appreciated
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-13-2015 01:09 AM
Hi Mukesh,
As given in http://wiki.servicenow.com/index.php?title=Database_Views#Relabeling_a_Column&gsc.tab=0
and also other threads on this topic Re: Is it possible to change column labels in reporting?
I have just done this report label changes:
1. When you have created this DB view, you must have specified a "variable prefix" for that table for example,
you might have give ciRel for cmdb_rel_ci table etc. This "ciRel_" is the one you will be using while overwriting the field names for the db view only.
For example to relabel "sys_created_on" to "Report Date"
you will create the new field Label from System Definition > Language File.
Once the field label is added, you can go back to your DB View, click on "Try It" to test the data, and
1. If the column is already there then refresh the list OR ELSE
2. Add the new label using List > Configure > List Layout and adding the new label.
3. Once you can see the new column, you can then add this in the report.
Hope it helps.
RC.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-31-2019 01:40 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-28-2019 12:47 AM
Thanks!! this was helpful 🙂