How to show the records sort (z to a) on List view of a table

[Mahendra RC]

Hi ServiceNow Experts,

I have a requirement where I need to show the records sorted in 'sort (z to a)' order by 'Sent on' field. Can anyone please help me to know how I can implement this. Please refer the below screenshot.

Currently the record are sorted in 'sort (z to a)' order by 'Created' field, I want this by default on 'Sent On' field when I open the table from Left Navigation Pane.

Thanks & Regards,

Mahendra Choudhary

[Anurag Tripathi · Accepted solution]

Hi,

The below link explains exactly the same

https://docs.servicenow.com/bundle/jakarta-platform-administration/page/administer/list-administration/concept/c_ControlTheListSortSequence.html

[Aakash Shah4]

Hi Mahendra,

Please add this in the arguments section

&sysparm_order=u_sent_on &sysparm_order_direction=desc

Please replace your appropriate variable name.

Regards,
Aakash Shah

[Rakshanda Kunte]

HI @Aakash Shah4 ,

How Can I use this in the Flow Action?  I tried to use it but it gave me the syntax error.

[Ziaur Rahman1]

Hi Please 

Go on the Module under System Definition and Then on argument field please remove the condition created by and add condition for sent on..

Please read

To sort a list by multiple fields, remove everything from the filter field and place it in the arguments field. For example, if the filter specifies [Active] [is] [true] and you want to sort by category and subcategory, remove the condition and put the following in the module arguments:

active=true^ORDERBYcategory^ORDERBYsubcategory

This argument first orders by the category and then orders by the subcategory. If you want any field to be a descending sort then change ORDERBY to be ORDERBYDESC.

Thanks

Ziaur Rahman