Search must work on 'Contains' instead of 'starts with'

[Rachael12]

Hello,

We have a reference variable on which the search the works based on 'starts with' while the requirement is that the search must work based on ' contains'. Ex : abc xyz so even if I type xyz, it should come up as option in search.

I tried using Lookup field, the search worked based on 'contains' but the variable a lot of filters and so did not support other features.

What else can be used to meet the requirement? Is there a way that when a user starts typing automatically asterik(*) gets added infornt of it?

Thanks in advance

[Omkar Mone]

Hi

This should help you-

1. Disable the glide.ui.ref_ac.startswith system property . See Improving Auto-Complete Queries.
2. Navigate to User Administration > User Preferences.
3. Select the preference "'<referenced table>.autocomplete.contains"'.
4. Set the value field to true.
5. Log out and log back in to immediately display the updated search.

Regards

Omkar Mone

[Rachael12]

Hi Omkar,

Thank you for the solution!

Just an additional query, when we search in Lookup fields the keyword being searched comes underlined in the options made available through search.
Can the same be done for Reference variable?

[Omkar Mone]

Hi Rachael,

I don't think that is possible because we don't have access to those areas.

Mark correct answer to close this thread

Regards

Omkar Mone

2020 Community MVP