Applying default sort to lists in SOW

[Rob Banks]

Hi all, hope everyone is doing great! I've been looking around a bit trying to find the answer to if it's possible to apply a default sorting method in SOW UX Lists that can overwrite a user's preference. I know this might not be standard, so I'm thinking it may not be possible, but I wanted to ask here before throwing in the towel. I found the SN documentation for controlling sort sequences and was able to configure incident.db.order / incident.db.order.direction preferences that will be used if the user does not have any of their own preference set, but this is immediately overwritten if the user applies their own sorting. I saw mentioned in the page about setting sysparm_order arguments, but I feel that this only applies to modules in the All menu, though it is entirely possible that I'm missing where I would enter this for SOW lists.

If anyone could either point me in the right direction or just confirm that this isn't necessarily possible, I would greatly appreciate it either way. 

[Pradeep Thipani · Accepted solution]

Hi @Rob Banks ,

Have tried from the sys_ux_list.LIST table? 

If you wanna restrict column sorting use below option

Example URL: https://<<YOUR_INSTANCE>>.service-now.com/sys_ux_list.do?sys_id=7d8a721ac3013010965e070e9140dd63&sysparm_view=&sysparm_record_target=sys_ux_list&sysparm_record_row=7&sysparm_record_list=configuration%3D48c6565ec3013010965e070e9140dd39%5EORDERBYorder&sysparm_record_rows=37

Thanks,

Pradeep

[Rob Banks]

Ignore my initial response, I somehow missed entirely the "Add sort" button. Thank you for this! I completely overlooked this somehow.