Description
How to sort the list by a column (example: number) in descending order using Data Table from URL Definition Widget.
Procedure
Currently the only way to sort from a Data Table from URL Definition widget is using the URL parameters to display the data in a sorted list.
For example, if you click on Sort (z to a) on number column on Service Portal, the URL will get updated to:
https://<instance-name>.service-now.com/sp?id=list&table=<table-name>&filter=&target_page_id=ticket&spa=1&p=1&o=number&d=desc
The two extra added paramaters "o=number&d=desc" will display the expected sorted list. There is no pre-defined way to set the sorting for this widget.
As an alternative, Data Table from Instance Definition widget can be used which lets you define the "Order by" and "Order Direction" fields to sort by required column. These fields would be need to be updated on widget instance.
Applicable Versions
All versions