Search by "Contains" on Service Request

[Sandy7]

Hello,

I have a service request with a variable that I want to search by the user id of a person (this is a reference variable pointing to the sys_user table). 

The variable name is called "user_name".  In the variable attributes section, I've added: ref_ac_columns=user_name and this allows me to search by the user_name. 

however, some people have multiple "user_name" records (such as 12345, x_12345. and ur_12345).

I want to be able to search on this variable field where user_name contains "12345" and have the  above 3 selections displayed. 

Can someone point me in the right direction? Is this something I need to add to the variable attribute?

Thank you!

[sach1]

It should show the three records even if you search 1234. Isn't it working in this way ?

[Sandy7]

Hi - no it's not working that way. it's only returning exact value of '1234'

[Saurav11]

Hello,

Please do the below:-

In the system properties make this property as glide.ui.ref_ac.startswith as false

Then create a user preference:-

Name: sys_user.autocomplete.contains

System: checked

User: leave this blank

Type: true | false

Value: true

Please mark my answer as correct based on Impact.