A reference field can be configured to add columns to the autocomplete search so more information can be presented to the users. This article details the steps on how to configure such field to do a 'contains' search for all the columns that are used.
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)
User: leave this blank
Type: true | false
4. After the user preference has been created log out and back into the instance for it to take effect