Multi selection for variable in catalog item

Akshaykhare
Tera Contributor

I have a requirement where I need to create a field on catalog item which should reference to sys_user table and should allow multi-selection. Along with this the dropdown should show combination of name and email of the user. I can use reference variable which fulfil every requirement except multi-selection. I tried using list collector and it allows multi-selection but the dropdown is does not show combination of name+ email. 

Please suggest me how to implement this requirement. 

1 ACCEPTED SOLUTION

Adrian Ubeda
Mega Sage
Mega Sage

Hello Akshaykhare, 

For showing more fields than the display value in the field you need to add attributes inside the variable attributes: ref_auto_completer=AJAXTableCompleter,ref_ac_columns=field_A;field_B,ref_ac_columns_search=true
Fill in the field_A/B the fields of the table you want to show:

AdrianUbeda_0-1757665503808.png

 

If it was helpful, please give positive feedback! ✔
☆ Community Rising Star 22, 23 & 24 ☆

View solution in original post

2 REPLIES 2

Adrian Ubeda
Mega Sage
Mega Sage

Hello Akshaykhare, 

For showing more fields than the display value in the field you need to add attributes inside the variable attributes: ref_auto_completer=AJAXTableCompleter,ref_ac_columns=field_A;field_B,ref_ac_columns_search=true
Fill in the field_A/B the fields of the table you want to show:

AdrianUbeda_0-1757665503808.png

 

If it was helpful, please give positive feedback! ✔
☆ Community Rising Star 22, 23 & 24 ☆

Rafael Batistot
Tera Sage

Hi @Akshaykhare  

 

The attribute section should read: ref_auto_completer=AJAXTableCompleter,ref_ac_columns=name,email,user_name,ref_ac_columns_search=true.

 

https://www.servicenow.com/community/itsm-forum/show-name-user-name-and-email-in-a-reference-field-o...