Choose the field to display in a list collector

Clement Dos San
Tera Contributor

Hello,

I populate the list collector  from a custom table.

There is two particular fields : application and AD Group.
Currently , the list collector show the application (MU****IS) but I want to show the AD group

 

2023-09-11 11_16_11-Window.png

How I can do that ?

 

Here an example of data

MU****IS  ADgroup1

MU****IS  ADgroup2

MU****IS  ADgroup3

 

Thank you

2 ACCEPTED SOLUTIONS

Shruti
Mega Sage
Mega Sage

Hi,

Go to the dictionary entry of AD group field and make it display true

ShrutiW_0-1694425064924.png

 

View solution in original post

Ankur Bawiskar
Tera Patron
Tera Patron

@Clement Dos San 

Out of the box the list collector will only show field which is marked as Display=true.

you can have only 1 field which is marked Display=true

Solution

1) create a custom field of type string and store the concatenated value of both the fields into this

2) make this newly created field as Display=true in dictionary

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

4 REPLIES 4

Shruti
Mega Sage
Mega Sage

Hi,

Go to the dictionary entry of AD group field and make it display true

ShrutiW_0-1694425064924.png

 

Vishal Birajdar
Giga Sage

Hello @Clement Dos San 

 

You can add Variable attributes to list collector

 

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=<name of column1>; <name of column2>,ref_ac_columns_search=true

 

<name of column1> => put column name you want to display in list collector

 

VishalBirajdar7_0-1694427508923.png

 

 

 

 

Vishal Birajdar
ServiceNow Developer

I know one thing, and that is that I know nothing.
- Socrates

Ankur Bawiskar
Tera Patron
Tera Patron

@Clement Dos San 

Out of the box the list collector will only show field which is marked as Display=true.

you can have only 1 field which is marked Display=true

Solution

1) create a custom field of type string and store the concatenated value of both the fields into this

2) make this newly created field as Display=true in dictionary

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Clement Dos San
Tera Contributor

@Vishal Birajdar   I saw an dozen of times this solution with this attribute but it does not work with list collectors.
@Shruti  it works !

@Ankur Bawiskar you're right. It only works with one field at the time. The system automaticaly disable the display of the former field.

Thank you all !!