How to automatically order my display list

[rafas_2703]

Hi everyone!

I was wondering if and how is it possible to automatically order a display list for every user?

(Image is attached)

As you can see, it is ordered but it was manual, sometimes when the case is created this is not by order. How can I automatically order it every time for every user?

Thank you!

[tharun_kumar_m]

Hi Rafas,

You can create a new record in the user preference table(sys_user_preference) as in the below screenshot. In my example the table name is "u_testtable" and column name on which I'm sorting is "u_c3".

If you leave the user field empty, it will apply for all the users who have not set any preference on this table.

If the value field is empty, then the order is Ascending and if it is DESC, then the order is Descending.

Please refer to https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0868617  for more information.

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

Best regards,

Tharun Kumar