How to add Sort for the List view of Records from Z to A

[RathanK]

Hello People,

Hope everyone is doing great.

I need to configure the list view of records from Z to A, so whenever someone opens the list view, the newly created record should be on the top and the numbering should be from descending to ascending.

PFA the screenshot.

[Di Zhang]

Please try this solution: How to change the default sort order on the Knowledge Result Sort Widget - Support and Troubleshooti...

[Utpal Dutta]

Hey Rathan,

You can edit the module URL with something like "/u_issue_tracking_list.do?sysparm_query=u_statusNOT%20INCanceled%2CResolved^ORDERBYDESCu_tsf&sysparm_view=IssueDisplay"

In above url order by is defined. This will order your list.

I hope my answer helps, if it does please mark it helpful and accept the solution.

Thanks

[Amit Pandey]

The default sort order is stored as a user preference. You can override the default sort order by creating a record in the sys_user_preference table with the following values:

Description: Knowledge Result Sort Widget default sort order
Name: knowledge.portal_search.sort.field
System: True
User:  <Keep  Empty>
Type: string
Value:  sys_updated_on:desc

The Value field will hold the desired default sort order. In the above example it will sort on newest. Please be aware that the moment a user sorts on something else that user will keep that as their default as it gets stored as their user preference which overrides the system one.
Also the order of the sort fields and the sort field labels doesn't determine what default sort order is being used. For example if you only add the above user preference then the default sort will be on the second field.

[G Ponsekar]

Hi @RathanK ,

check this SN doc 

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

Thanks, GP