To sort a field in ascending order globally

[AbubakarSiS]

Hi ,

I have created a new custom table. I need a specific field needs to be in ascending order for all users globally without personalizing the list.

How can i achieve this?

Thanks in advance

[Eshwar Reddy]

Hi @AbubakarSiS 

Refer to the below link 

https://docs.servicenow.com/bundle/xanadu-platform-administration/page/administer/list-administratio...

Please mark this response as Correct and Helpful if it helps you can mark more that one reply as accepted solution.

Thanks
Eshwar

[Sumanth16]

Hi, 

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

If I could help you with your Query then, please hit the Thumb Icon and mark it as Correct !!

Thanks & Regards,

Sumanth Meda