Sort the values for a reference field in alphabetical order

Sravani Koyya
Tera Contributor

‎03-13-2024 03:09 AM

Hi,

I am having a field called case reason in HR Cases table which is reference to a custom table 'u_case_reason'. I want the values of the case reason should be sorted in alphabetical order both in record producer and case form for all users.

 I tried using dictionary attributes but didn't work.

Can anyone please provide me any other approach to achieve this.

 

@Danish Bhairag2  @Dr Atul G- LNG 

0 Helpfuls
  • 518 Views
2 REPLIES 2

Dr Atul G- LNG
Tera Patron
Tera Patron

‎03-13-2024 03:17 AM

Hi @Sravani Koyya 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0787403#:~:text=Description,w....

https://www.servicenow.com/community/developer-forum/sorting-choice-list-alphabetically/m-p/1883041

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************
0 Helpfuls

Sravani Koyya
Tera Contributor
In response to Dr Atul G- LNG

‎03-13-2024 12:22 PM

We created a custom table and the field values are not choices which we have given.

We used filed label for the values to add into that table directly.

0 Helpfuls