Search with User Id instead of user name

[Apoorva12]

Hi All,

We have a reference field caller (referring to  sys_user table) on a service catalog form, currently if we are searching with the user name it is giving results based on user name but we want to search with user id instead of user name.

Can anyone guide me here.

Thank you !

[Murthy Ch]

Hi Approva,

Please add this in variable attributes and give a try:

ref_ac_columns=user_id  //map your backend name of the UserID

It will add the userid along with username 

Refer this for documentation:

Variable attributes

[Apoorva12]

Hi Murthy,

Thanks for the quick response but i tried this also but its not working for me.

It is still searching with user name instead of user id.

As per our requirement if i am searching with user id it should give result based on user id but with this attribute it is still searching with user name but user id is coming in search result

[Apoorva12]

I want it to search with user id not with user name

[Murthy Ch · Accepted solution]

It should be like below:

ref_ac_columns=email;user_name