How to search according to any word in description?

[Akki1]

Hi,

I have a reference type variable created which has variable attributes as 

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_group_name;u_group_description,ref_ac_columns_search=true

I want key search functionality for the description. i.e when i search anything from the description the results should be shown up.

Currently by using the above varaible attributes we can search only if we enter complete desription but not by using any word from description.How can we achieve this ?

For example description is " I love servicenow "

so if i start seaching from start i.e If I enter 'I' then it will show but if I start from any term in between like 'love' it will not show

[Aman Kumar S]

Hey,

This has to be changes by adding global search by enabling a system property, but this will be a global change.

Procedure:

1. Ensure that 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 user preference:

Name: table_name_being_referenced.autocomplete.contains (i.e. sys_user.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

Feel free to mark correct, If I answered your query.

Will be helpful for future visitors looking for similar questions 🙂

[Aman Kumar S]

Hey @Akki 

Didn't hear back on this.

Is your issue resolved? If yes, feel free to mark helpful/correct, so it will be helpful for others looking for similar query.