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  

[Kalaiarasan Pus · Accepted solution]

element name should be given like

viewtableprefix_fieldname

EX : ctask_closed_at

ctack is view table prefix and closed_at is view field

[Kalaiarasan Pus]

and table column in field label must the database view name

[scotty81]

Hi Kalai,

That worked like a charm.   Thanks,

Scotty

[Abinaya]

Hi Kalai,

Is there a way to relable a column on the database view which is dot-walked e.g. caller_id.location

I tried giving element as inc_ caller_id.location (where inc is the database view table prefix) but it dint work.Can you please help me out on this .