Populate User ID in List Collector Field

Piyush27 · ‎04-19-2023

Hi,

I am trying to see users when entering the user id in a list collector variable.

The list collector variable is pointing to the sys_user table. Below is the screenshot of the variable.

----------------------------------------------------------------

-------------------------------------------------------------------------

-----------------------------------------------------------------------------

This is how the catalog item looks on the portal

------------------------------------------------------------------------------

What I want here is - When I enter the USER ID in the field it should show only the USER IDs.

But in my case, I have to type the complete name.

Is there any way I can achieve this?

Regards,

Piyush

Sandeep Rajput · ‎04-19-2023

@Piyush27 I am assuming you would like to have the search performed on the user_name field like the following.

Here when I am typing admin, it has suggested me the user with user_name admin.

In order to achieve this you need to paste the following string inside your Variable attributes of your user list collector variable.

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=user_name,ref_ac_order_by=user_name,ref_ac_columns_search=true,ref_ac_display_value=false

Hope this helps.

View solution in original post

sushantmalsure · ‎04-19-2023

Hello @Piyush27

i think you need to add variable attributes in that variable

Like for autocompletion you can use : ref_auto_completer=AJAXTableCompleter

you can refer all the variable attributes in following link for more details:

https://docs.servicenow.com/bundle/tokyo-servicenow-platform/page/product/service-catalog-management...

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Regards,Sushant Malsure

Piyush27 · ‎04-19-2023

Hi Sushant,

I tried but it is not working.

What I want when I enter USER ID only that should populate in the list collector variable (field)

Sandeep Rajput · ‎04-19-2023

Did you try mine solution?

Ankur Bawiskar · ‎04-19-2023

@Piyush27

It won't show User ID once you select the record.

Reason: On user table name field is Display=true so it will show only Name

to show user ID you need to mark User Name field as Display=true in sys_user table

Note: This will be a global change and impact every reference field which refers to User table in entire instance. So discuss this with your customer before doing that.

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