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

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

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
Kilo Patron

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...

If you found this response helpful, please mark it as Helpful. If it fully answered your question, consider marking it as Correct. Doing so helps other users find accurate and useful information more easily.