Ordering Reference field Drop down

[tonystark]

I m having a custom table which i set as a reference for one of my dropdowns(Reference field made as dropdown). Is there a way where i can set the order in which the order would be displayed in my dropdown?

In my dropdown, records are being displayed in the alphabetical order., but i want those records to display in the same order as in my table.

Thanks,

Tony

ctomasi

[Pradeep Sharma]

Hello Tony,

I don't think this is possible. At the max, you can define the dictionary attribute to filter records i.e sort the autocompletion choices based on the column name passed.

Auto-Complete for Reference Fields - ServiceNow Wiki

Enhancement requests: Using HI to tell us how you would improve the ServiceNow product

[erik_brostrom]

Pretty sure in the advanced ref qualifier section you could add your query plus the ORDERBYfield.

Example

active=true^ORDERBYname

I could swear that works, but I might be wrong - give it a shot.

[Chuck Tomasi]

 i want those records to display in the same order as in my table

What exactly does this mean? If you have five fields, the list of records could be sorted by any of those fields.

[tahnalos]

Yes, but while you can set the order of these fields by autocomplete or search, it doesn't seem to apply when you use a choice list for your references.

I have the same issue as the choice list sorts the available options alphabetically, but I also have an order field and would like to sort the choice list based on that.

Thanks