Sort In Ascending For Reference Field

[manas5]

I have a reference field that needs to show list data in a pop-up with ascending order sort, I have updated the attribute of the reference field.
is there a way to that we can make the default ascending order for reference pop up?

[Willem · Accepted solution]

Hi Manas,

Have you seen this Community post:

https://community.servicenow.com/community?id=community_question&sys_id=b8090fa1db5cdbc01dcaf3231f96...

I would assume you could set a user preference for this that is system wide so everyone should get it unless they change it themselves to something else.

The user preference should be

TABLE_NAME.db.order

The value should be the field name to sort on

You can also create a user preference named

TABLE_NAME.db.order.direction

The value should be ASC or DESC depending on if it should sort ascending or descending

Make sure to mark the System checkbox so it becomes systemvide

Example for Incident table

incident.db.order -> value = number

incident.db.order.direction -> value -> DESC

[Willem]

I tested this for the Caller reference field on Incident:

Then sorted:

It creates the user preference:

Following the steps from the mentioned Community post you can make that a system wide preference by clearing the user and checking the System checkbox.