Unable to change column order in List Collector– Display field always first

[Kishore47]

Hi All,

I have a requirement in a Catalog Item where I am using a List Collector variable referencing a custom table u_new_device.

This table has two fields:

• u_application (set as Display field)

• u_business_service

In the List Collector, I have configured the following Variable Attributes:

ref_auto_completer=AJAXTableCompleter,
ref_ac_columns=u_application;u_business_service,
ref_ac_columns_search=true

Current behavior:

• The dropdown shows u_application (Display value) as the first column

• u_business_service as the second column

My requirement:

• I want u_business_service to appear as the first column

• u_application as the second column

• But the selected value should still display u_application (Display field)

I tried changing:

ref_ac_columns=u_business_service;u_application

But still the display field appears as the first column.

Is it possible to change the column order in a List Collector (AJAXTableCompleter) while keeping the display field unchanged for selection?

Or is this an OOTB limitation of ServiceNow?

Any guidance or workaround would be appreciated.

Thanks!

[Rafael Batistot]

Hi @Kishore47 

The "sys_ref_list" list layout of the target table controls the elements that are displayed under the list collector. 

Here are the steps:

1. Identify the list table the list collector variable is referencing.
2. Navigate to sys_ui_list.LIST from application navigator and filter the records with that table name you found in step1
3. Then select the record that has the View as 'Reference List'
4. In the related list, you will see List Elements. These are the fields that you see below the list collector variable after selecting a value.

if no exist the view “sys_ref_list“ create a new one 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0783678