question Change field label dot-walking in database view in Community Central forum

Change field label dot-walking in database view

Rick_Sousa — Wed, 27 Nov 2024 18:02:13 GMT

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?

Re: Change field label dot-walking in database view

Brad Bowman — Thu, 28 Nov 2024 12:06:11 GMT

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?

Re: Change field label dot-walking in database view

riicksousa — Thu, 28 Nov 2024 13:03:12 GMT

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.

Re: Change field label dot-walking in database view

Drew Carpenter — Fri, 21 Mar 2025 14:27:01 GMT

Any updates to this?

Re: Change field label dot-walking in database view

phgdet — Fri, 25 Jul 2025 08:08:06 GMT

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)