Display Desired Field Columns in reference field

[naga karthik1]

Hello All,

I am creating a new catalog item in which I used a reference field "Name of the user" which takes the values from sys_user table.

While clicking on search icon currently it is showing the user records with columns ( userID, name , first name , last name etc) displayed. Where as I would like to have columns (Company, email address, mobile phone, Manager) to be displayed when we clicked on the search bar in the field "Name of the user".

Kindly some one let me know how can I achieve this?

Thank You.

[BharathChintala]

@naga karthik1  this is possible but it will be like global change wherever you have user table as reference all will be changed to this.

changing those list fields particularly for item reference is not possible.

Description

This article describes how to configure a list layout for a reference list pop-up view. This example uses the Caller field on the Incident table.

Procedure

1. Navigate to System UI > Views.

2. Search for name = sys_ref_list and open the record.

3. Select the Lists related list.

4. Search for the table for which you want to change the view and open the record.

   This is the table you are referencing.

   Once you open the record, you will see a related list called List Elements. This related list shows the columns that will be displayed on the pop-up view for the reference field.

5. Modify the List layout by either deleting columns or adding new ones by clicking New. 

   If you are creating a new column, you can use the same format as one of the other columns on the view. For example:

   
   
   • Element: Column name
   • Position: Position you want this column to be in relation to the rest
   • List ID: Table
   https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0686318

[Sergey Aleksand]

You can use this in the Type Specifications tab of the Variable and set it in the field Variable Attributes: ref_auto_completer=AJAXTableCompleter,ref_ac_columns=name,ref_ac_columns_search=true