How to set the default sorting in the reference field for all the user in custom scope?

[Ankita Kolhe]

Hi Community,

I want to set default sorting in  the reference list based on ASCENDING order of 'ORDER' field:-

I tried with the solution mentioned on below link:-

https://www.servicenow.com/community/now-platform-forum/sort-in-ascending-for-reference-field/m-p/10...

Also, tried with the below Business rules:-

1. Before Insert/Update BR with condition- Name is iogc_choice_definitions.db.order

2.Before Insert/Update BR with condition-Name is iogc_choice_definitions.db.order.direction

But neither of the solution is working.

Could someone please help me on this?

Thanks,

Ankita

[Dr Atul G- LNG]

Hi @Ankita Kolhe 

Might be helpfulhttps://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0725720 

[Ankita Kolhe]

Hi Atul,

Thanks for your reference but it's already configured & still not working.

[Dr Atul G- LNG]

Hi @Ankita Kolhe 

I tried the same at my end and it is working , may be give a cache.do

[Ankita Kolhe]

@Dr Atul G- LNG  Still not working. My requirement is to set default sort order in reference field.

For Example:-

If user opens the reference list then default sort is:-

But when user change the sort order by clicking the choice value column, the sort order changes as below:-

So when user close the reference pop up window & again opens the reference list, then default sort should be applied(see screenshot 1) instead of the sort did by user(screenshot 2).

Thanks,

Ankita