Showing Multiple Columns in a List Collector in Service Portal

jmiskey
Kilo Sage

So, I need to have a list on my Service Portal form where users can select multiple columns, hence I am using a List Collector.   However, I want to show more than one column of information in that list.   I found this link here: https://www.servicenowguru.com/system-ui/customizing-slushbucket/   that tells you cannot do that, but you can edit the "sys_ref_list" to show multiple fields on information below the List Collector as you hover over each item in it.

However, I cannot seem to get this to work for me.   It only shows field listed in the List Collector, and not the other fields as shown in the link.   I cannot figure out what I am doing wrong.

I am using Helsinki, and the table that I am pulling the information from is a Custom table.

Any ideas?   Maybe something changed between versions (the article referenced is pretty old)?

Thanks

1 ACCEPTED SOLUTION

Rushit Patel2
Tera Guru

Hi,



do you want more info to be displayed where user is searching? i.e dropdown..



if yes then you need to update reference attributes



ref_auto_completer=AJAXTableCompleter,ref_ac_columns=department,ref_ac_order_by=department



http://wiki.servicenow.com/index.php?title=Auto-Complete_for_Reference_Fields#gsc.tab=0



(please mark helpful/like/correct if it helps)


View solution in original post

11 REPLIES 11

jmiskey
Kilo Sage

Rushit,

You were very helpful with this question last year, but now I have a little twist.  I have the same need as before, but I am also already using the Reference Qualifier box for criteria,  I currently have the following in it:

javascript:'u_inactive=false';

 

So, the question is, can I combine these things, so I can filter, sort, and display two columns in my List Collector, all at the same time?

 

Thanks

jmiskey
Kilo Sage

Figured out my latest question.

 

For filters, use the "Reference qual" field and enter like:

u_inactive=false

 

For sorting and adding additional fields, use the "Variables attributes" like this:

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_description,ref_ac_columns_search=true,ref_ac_display_value=false,ref_ac_order_by= u_order

After adding this attribute, the ac still did not display within the List Collector.

I think we would need more details on the nature of your problem.

What does your data look like in the data table?

What are the key field names?

What exactly are you attempting to do?

We would like to capture the location's 'Address'. 

When adding the attributes suggested, the user will be able to see the 'Name' and Address in order to choose the correct location BUT when selected from the List Collector only the 'Name' is captured. 

find_real_file.png