Notifications

97 views

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

Additional Information


Data Table from URL definition widget

Data Table from Instance definition widget

Article Information

Last Updated:2019-05-21 11:51:02
Published:2019-01-25