How to Sort Reference field in descending order of updated Date

[Varad Bhagwat1]

Hi Folks,

I have one reference field which referencing "sys_report" table and I wanted to sort the record displayed in reference field in descending order by Updated Date so that recently updated report should display first.

Anyone knows how we can do that?

For both Native and Portal View

[Anirudh Pathak]

Hi @Varad Bhagwat1 ,

Please have a look at this article - 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0725720

[chetanb]

Hello @Varad Bhagwat1 ,

Follow the steps -

1) Right click on the label for the field you want to sort and choose: Configure Dictionary

2) In the Attributes related list, click the New button 

3) In Attribute input field, choose: Reference sequence

4) In the Value field, input the column name you wish to sequence on

5) Submit the attribute record

if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Regards,

CB

[Ademir Amaral1]

Hi @Varad Bhagwat1 

There is this post with a step by step guide:
https://www.servicenow.com/community/process-mining-article/reference-field-autocomplete-sort-the-li...