Using ref_ac_columns on List Collector Variables

Uncle Rob
Kilo Patron

According to docs, ref_ac_columns is valid for use with List Collector variables.  But when I do that, I'm still only getting the Display column of the table, even when searching

1 ACCEPTED SOLUTION

Can you try

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_legal_entity_id;u_org_unit;u_legal_entity_name,ref_ac_columns_search=true

View solution in original post

8 REPLIES 8

Duane is the best!

Hi there!  I tried this on my list collector but I am still not getting the desired results.  Will this work for a custom table that extends the task table?  I have also tried putting a dictionary override on the task table for the display value and created a concatenated display on the custom extended table and I still only get the "number" field.  This is the attribute I put on the list collector variable for a record producer:  ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_user;u_account_type;u_business_application;u_access_level,ref_ac_columns_search=true

Also, I noticed that the SN docs page shows a screenshot with the field label "variable attributes".  My variable screen (for the record producer) only shows "attributes".  Variable attributes is not an option for the form layout either.

This helped me out. Thank you @Mike Patel 

Hadyn
Tera Expert

The above did not work for me. However for those that stumble upon this thread like I did, I found the below worked:
https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0780875 "How to customize the fields shown below the slush bucket for the selected record."

Description
Slush buckets may cause confusion for end users, because the display values shown may be the same for multiple records. In this case, it is helpful to have additional fields shown below the slush bucket for the record selected. This KB describes how to customize the details/fields which are shown when a record is selected.

Release or Environment
New York and previous

Cause
The behavior is caused by the presence or absence of a 'sys_ref_list' View defined for the table being queried. If no such view is found for that table, only the display 'name' will appear which may not be helpful enough.

Resolution
The resolution is to define a 'sys_ref_list' for that table. This can be done by following these steps:

Navigate to https://instancename.service-now.com/affected_table_list.do?sysparm_view=sys_ref_list
Use the List Controls to select Configure > List Layout and select the desired fields, then save.
That is all it takes to define/customize the 'sys_ref_list' view. Please note this may already exist for your table; this view is used to display columns whenever a reference look-up is invoked via a reference form field.