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

12 REPLIES 12

What changes exactly?

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?