Reference filed on Service Portal ignores sort order

[brianlan25]

I have a reference filed and list the times for users to select from.  I added a user preference to sort the what show by a sort order filed.  This works fine in service catalog but does not work in Service Portal.  How can I get the sort order t work in Service Portal.

Service Catalog when you click on the magnifying glass:

Service Portal when you cock on the drop down:

[brianlan25]

You created a choice list not a reference which points to a custom table.  The table has two items in it.  Sort Order and Hours. Hours is the filed that has  a display value set to true.

[brianlan25]

note that this is a reference field on a service catalog item (record producer)

[brianlan25 · Accepted solution]

Figured it out.  For Service Catalog variables I just needed to add a variable attribute ref_ac_order_by=u_sort_order.

[Deepika48]

Hi,

Do you have any idea like how to change the order of a reference field in descending order in service portal? 

Thanks