Reference field auto complete is not showing all results - Support and Troubleshooting

Reference field auto complete is not showing all results Issue  Symptoms When entering text into a reference field with autocomplete, the result list does not contain all the available entries and may not show a match even if you entered text that should exactly match with a particular result. You will see a (non-functional) link at the top of the list: "Showing 1 through X of Y".

Release All

Cause There is a system property glide.xmlhttp.max_choices which controls the number of results shown. If this limit is too low or the display order of the results is not set properly, specific results may not appear in the list.

Resolution You can add an attribute to the dictionary entry to order the results by the column of your choice. For example, to order a result set by the name field, you would add: ref_ac_order_by=name to the attribute field. You may also increase the limit of the glide.xmlhttp.max_choices property, but keep in mind this will affect all choice lists and will carry a performance hit.

Additional Information https://docs.servicenow.com/csh?topicname=c_AutoCompleteForReferenceFields.html&version=latest