Reference Field Choices Not Displaying in Sequential Order

[shalini1]

Hi Community,

I have a reference field (u_abc) in my ServiceNow instance, which pulls its values from another table that contains only 6 records. These records have a sequential order.

When I click on the mirror icon to select a value, the choices appear in the correct sequential order. However, when I type in the field (with my cursor inside), the choices are not displayed in the same sequential order.

I have already verified that the records in the referenced table are sorted correctly by the sequence field.

Is there a way to ensure that the reference field choices are displayed in sequential order when typing in the field, not just when using the mirror icon?

Any insights or suggestions would be greatly appreciated!

[JenniferRah]

In the variable attributes add a ref_ac_order_by statement with the name of the field you want to sort by. In the example below, it would sort by the Item Category field.

ref_ac_order_by=u_item_category