Rename dot walked columns in a report created on database view

Anubhav24
Mega Sage
Mega Sage

Hi All,

I have created a database view using three tables change_request , sc_req_item and sc_task and from sc_req_item table I have dot walked request fields by using configure list layout options. Now I have renamed columns using language files but the columns which are dot walked are not getting renamed properly. 

Query 1 : From where I can know the exact column names to mention it in language file element field

Note : When we configure columns to order them , there we have the column names I have referred names over there to mention it in element field while creating language file but for some it is working fine and for some it is not working fine.

Thanks in advance

1 ACCEPTED SOLUTION

Mark Manders
Mega Patron

You are adding those fields from another table by dotwalking. You are not putting them on that table. So to change the labels, you should do so on the table you are getting them from.

If my answer helped you in any way, please then mark it as helpful. If it resolved the issue, please mark it as correct. This way others will find it in the solved queue and helps them on similar queries.

Mark


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

View solution in original post

3 REPLIES 3

Mark Manders
Mega Patron

You are adding those fields from another table by dotwalking. You are not putting them on that table. So to change the labels, you should do so on the table you are getting them from.

If my answer helped you in any way, please then mark it as helpful. If it resolved the issue, please mark it as correct. This way others will find it in the solved queue and helps them on similar queries.

Mark


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

can you share screenshots and what's the expected outcome?

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Hi Ankur,

This is a feature only dot walked fields can not be renamed using language file , you need to keep them as is or change the label at table level