User is not listed when I search by Last name in Service Portal

[SanjivMeher]

Hi All,

I am using the form widget to display a ServiceNow form. It has a field Application which is reference to User table.

When I try to search by my first name, it works fine. But when I search by my last name, it can't find my name.

When I add a '*' to the front, it works fine. How can I make it work always by just typing the Last name

[Deepak Kumar5]

You have to add 'ref_ac_columns_search' in your User table attributes.

This may be useful - Re: List attributes beyond name for user reference fields

[sergiodecristo1 · Accepted solution]

Hello :),

is just edit your Reference Field Attributes and add :

ref_ac_columns=first_name;last_name,ref_ac_columns_search=true

Sergio

Mark Correct /Helpful /Like based on the effect of response.

[SanjivMeher]

Is it possible to default search to contains? I also want to have same functionality for other reference fields.

For ex, if I want to search by group name, i should be able to search by any character, not just by the first few letters.

For ex, If group name is ABC_Windows_Support, when i type Windows, it should also display this group.

[sergiodecristo1]

Sanjiv ,

u ask a different thing before, so I answer at what u   ask . So please put correct or helpful  

Sergio