Reference search After space word not visible

[Sirri]

Hi All,

I have requirement as per the below concern:

We have one field Select an application from the list type is reference(cmdb_ci_business_app).

There is one application name( Corel WinZip).

When we search in reference field in portal with Corel it's showing. But when we search with Winzip It's not showing.

As per my understanding if I change from reference to lookup field it will show But If we change like this we should want to change multiple script.

Please let me know without changing to lookup. How can I achieve this by using type reference.

Please find the attached documents for better understanding.

Thank you

[Brad Bowman · Accepted solution]

You can enable the cmdb_ci_business_app table for 'contains' searches following these steps

1. Ensure that the Value of the system property "glide.ui.ref_ac.startswith" is set to false.

2. Confirm that the reference field has similar dictionary attributes as the following:

ref_ac_columns_search=true, ref_ac_order_by=column_name, ref_ac_columns=column_name1, column_name2, ref_auto_completer=AJAXTableCompleter

3. Create the following record on the sys_user_preference table:

Name: cmdb_ci_business_app.autocomplete.contains

System: checked

User: leave this blank

Type: true | false

Value: true

4. After the user preference has been created log out and back into the instance for it to take effect

[Sirri]

@Brad Bowman  ,

I hope this is the article for this right:

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0823869

Thank you

Thank you