Change field label dot-walking in database view

[Rick_Sousa]

In English

Hello community, I'm creating a database view, but one of the fields I inserted in the list layout is dot walking, I need to change the label of this field, I tried to change it using the Field label <sys_documentation> but it didn't work and as in the database view it's not possible create script, is there any way to change this label?

==========================================

Português

Olá comunidade, estou fazendo uma database view, porém um dos campos que inseri no layout de lista é dot walking, preciso alterar a label deste campo, tentei alterar pelo Field label <sys_documentation> porém não deu certo e como na database view não é possivel criar script, existe alguma maneira de alterar essa label?

[Brad Bowman]

Using the Location field on the sys_user table as an example, if I change the Label to MyLocation or whatever it shows that everywhere - on the User form, dot-walked in a list layout in a database view,...  Are you trying to only change it for the database view?

[riicksousa]

Hello Brad!

Yes, I want to change the label only in the database view I created, without changing the original label in the departments table. The field is a dot walking from the 'sys_user' table to the 'department' table. The field is currently labeled 'Parent', but I need it to display as 'Executive Area' only in my database view.

[Drew Carpenter]

Any updates to this?

[phgdet]

A few workarounds for this case:
1. Create an onLoad script to override label:

g_form.setLabelOf('case.available_course','Course');

2. Create a calculated value field with your desired label/name and get value from the original column (displaying purpose only)