Can't relabel a column in a database view

[scotty81]

Hi,

I'm having difficulty in being able to rename 2 columns that appear in a database view.   Here's a simple example.   I created as shown below, which is merely a join of the incident and problem tables.   I'm just using this simple example here - what I need to do is more complex.

If you create a report that simply shows a list view of several of the columns, and want to see both the Incident number and Problem number (if one exists), you will find that both columns are labeled number, which comes from their respective tables.

So, I followed the directions in this article in the Wiki (Step 2.3.1): http://wiki.servicenow.com/index.php?title=Database_Views

  The instructions say to create an entry in the Language File which I did as follows.  

Table: u_incident_and_problem (the name of my DB view)  

Label: this is a test

Plural: left blank

Element: problem_id

However, I get an error when I enter the above.   So, I must be doing something wrong, but I'm not sure what the correct way to fix this entry is.

Thanks in advance.

Scotty  

[scotty81]

Paul,

Thanks for your reply.   It makes sense.   And, I agree, it defeats the purpose of being able to dotwalk to a field without having to add in another table into the DB view.   But, I'm glad there is a way if we absolutely have to do it.

Regards,

Scotty81

[HarshaVardV]

Were you able to find the solution for this, Abinaya?

[sbh]

Thank you!!! I wish ServiceNow would provide this additional information on their documentation at https://docs.servicenow.com/bundle/orlando-platform-administration/page/use/reporting/task/t_Relabel...

[pragar]

Hey Kalai,

I'm trying to do the same thing for both the columns (Both Number columns from INC and PRB). It works fine for first element but throws and error saying "Invalid Update" when I try to add the Language File for second Number Column.

Any thought here?

Thanks,

Priyanka

[Jeffrey Siegel]

I'm finding that a multi-level pivot table report ignores these language file renames, has anyone figured out how to get the relabel to show there?