Default Sort Order of Multiple Columns on Task Table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-29-2021 06:40 AM
Hello,
I received a request to display child case tasks on the HR form using a default sort order of the "Due Date" column and "Priority" column. The fields are to be sorted as such:
Column Sort:
BY Due date (earliest at the top)
THEN BY Priority (Highest to Lowest)
To set this default I went to the modules section and found All under sn_hr_core_task and applied the following in the Arguments field: ORDERBYASCdue_date^ORDERBYDESCpriority.
But when I impersonate as an HR Agent the list still shows a default sort order by Number. Is there somewhere else I should be setting this sort function? Have I updated this argument incorrectly? Any assistance would be greatly appreciated.
Thanks,
Danielle
- Labels:
-
Case and Knowledge Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-29-2021 01:15 PM
So when you view this list in your own account it looks good and is sorted the way you want right?
It could be that the person has made customizations to their view and your default may not take effect unless the click on cogwheel and set to default.
Also see if you can actually get a FULL URL link that you can paste into a browser tab and see the list the way you want- this would contain the arguments you need. You can then even explore making a fixed query link but the users wont be able to change what the query finds and will be limited in filter adjustments. Or you could save a filter- aka the one you have and share it. I want to say i remember saved filters remembering sorting orders and groupings. The more I think about it the more i want to say servicenow being so customizable even if you set it, folks could just refer to sort it another way and poof what you did is gone. So that is why the hard coded link might be what you need.
Looking forward to see more feedback from others and the results im sure the solution will be found.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-29-2021 02:20 PM
You can successfully set the original default order, but the sort order is a User Preference, so if an agent has clicked on any other column to sort by or even that column to change from ascending to descending order, it will override your settings with their personal ones.