list collector multiple columns

[satyaki]

Hi,

I have a requirement where i need to show multiple columns in a list collector.

For example,if i put the user table in the 'List Table' option in list collector i can see only the user names in the slush bucket.

But i want the email and department fields of the respective users beside their names in the list bucket which makes it 3 columns instead of one.

I have searched the community and cannot find any possible result.Please reply if anyone has come across any similar requirements.

regards,

Satyaki Sanyal

[Alex Edmiston1]

I'm viewing in Service Portal. To your point, I found that adding active=true to the filter reduced the search time from 3.5 seconds to about 2 seconds per user. Thanks!

[Sean35]

You've probably already figured this out but... You can improve the speed of the search by creating an index which includes all of the columns you're showing on your list collector.

Create a table index 

[Ashley]

Forgot to mention that it will work with Reference fields as well doing the same process.

Kind Regards

Ashley Pyle

[sivaprince231]

Hi 

Displayed multiple columns of data to a list collector that provides the name and email

Kindly enter value in the variable attributes filed , then you will get the required data on the list collector

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=name;email,ref_ac_columns_search=true

[Snowman]

While this works on the portal with list collectors and reference fields, it doesn't appear to work in native/ITIL view. I have (2) fields I want the list collector to search when someone types in a word but it appears to just search the first. Any ideas? type: jones in list collector. if name doesn't contain jones but email does (i.e. maiden name), then it should appear. ref_auto_completer=AJAXTableCompleter,ref_ac_columns=name;email,ref_ac_columns_search=true