How to sort by a column in Data Table from URL Definition Widget. - Support and Troubleshooting

How to sort by a column in Data Table from URL Definition Widget. Description  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:// .service-now.com/sp?id=list&table= &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

Additional Information Data Table from URL definition widget

Data Table from Instance definition widget