sys_user table - Display Value

[Vinay Krishna1]

Hello Everyone,

For reference fields of sys_user table, the display value is "name". But in the dictionary, I cannot find "name" or any column for which "display" is set to true. Not sure how the "name" is being used as a display value. 

[Ashutosh Munot1]

HI,

By default it is name for sys_user table. If you want you can make display true for other fields and then that field will be shown as display instead of name.

Thanks,
Ashutosh

[Pradeep Sharma · Accepted solution]

Hello Vinay,

Yes, you are right. Here how it is calculated.

Reference fields look for the display value in the following order:

1. A field with display=true in the system dictionary on the lowest sub-table for extended tables.
2. A field with display=true in the system dictionary on the parent table.
3. A field named name or u_name.
4. The Created on field of the referenced record.

Please note you can only set one field can be defined as the display value for a table.

Let me know if that answered your question. If so, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

- Pradeep Sharma

[Jaspal Singh]

Hi Vinay,

Rules for display_value to be determined goes as below.

1. Is there a field with the display field set to true.

2. Is there a dictionary override (for an extended table) with a display value override se

3. Is there a field called number, name, u_number, or u_name

[Allen Andreas]

Hi Vinay,

Just to clarify, there is a column for sys_user called Name:

As far as why that field is showing as display, you can reference some of the above posts which cover this and sort of say the same thing.

I just wanted to post this piece just to show that there is a column called Name for sys_user.

Please mark reply as Helpful, if applicable. Thanks!