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

[Inactive_Us1474]

As a workaround you can go to instancename.service-now.com/sys_user_list.do?sysparm_view=sys_ref_list and configure the list layout.

It would add the respective fields below the slush bucket.

[satyaki]

Hi Akhil,

I only need Multiple columns in the slushbucket. That is the requirement. Hope you are doing well.

Regards,

Satyaki

[Ashley]

Good Morning,

If your looking at showing different columns in a list collector it is very much possible, here is an example in Service Portal I am working on:

Go to the list collector variable, in the "Default" tab you should have a field called "Attributes", if its not there then unhide it, copy and paste the text below and your good to go as an example, edit the column names to show the ones you want.

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=email;company;department,ref_ac_columns_search=true

Hope this helps

Kind Regards

Ashley Pyle

[Alex Edmiston1]

Thanks, this definitely works although I've found the search to be much slower when using this method. 

[Ashley]

Glad it worked for you, when you say much slower, are you viewing this in the new Service Portal using a List Collector (Looks like a single line text field) or in the CMS Portal so you see a big chunky box?

Could also be the number of rows available... i.e. all users in the sys_user table, so could add a filter to only show Active accounts, with anything like this there will be a performance hit... but I haven't seen another way to do it yet.