How can I display multiple data colums in a list collector.

[Erin Mills]

Is it possible to display multiple columns of data to be able to have a list collector that provides the userid, full name, and title.  Right now I'm using the list collector and pulling from the sys_user table, but that is only displaying the full name

 

This just shows the Full Name, like A Fernandez.  I'd like it to show A Fernandez (name), AFRED(ID), Medical Assistant (Title), etc..

[Michael Fry1]

List collectors only display the field that is set as display = true.  You cannot have more then one field with display = true. You can modify the data below the slushbucket.

[Brian Lancaster]

I do not believe there is a way to do this.  List collectors display the field that is the display filed for the table.  Which is the case of sys_user is Name.  If you only highlight one name under the list collector it will display Name, First Name, Last Name, and Email (screenshot below).  However this functionality is lost when you use  Service Portal.  I'm trying to see if there is a way to add more columns to display under the list collector one someone is selected.

[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

 Then you can check into service portal , you will the result as your required.

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

[Adam Robbins1]

This solution worked for me.  I could see the additional columns in my list collector on the Service Portal.