Autocomplete suggestions in reference fields use a STARTSWITH search by default. Using an asterisk (*) before your search term turns it into a CONTAINS search.

You can use double asterisks (**) & it shows the first 15 records in the table sorted alphabetically by the table's display value column if not otherwise specified by the ref_ac_order_by attribute. The number of records can be controlled through the glide.xmlhttp.max_choices property. This also affects the number of recent selections shown to the user in the field or variable.

If my content helped you in anyway, please mark this content as BOOKMARK, SUBSCRIBE & HELPFUL

Best Regards,

Prashant Kumar (LearnIT)

YouTube Channel LearnIT: https://www.youtube.com/@learnitwithprashant

Blog LearnIT: https://medium.com/@LearnITbyPrashant

Prashant Kumar LinkedIn: https://www.linkedin.com/in/learnitbyprashant/

ServiceNow Community Prashant Kumar - https://www.servicenow.com/community/user/viewprofilepage/user-id/19635