Sorting via Dot walked fields

[Paul Kendall]

Hi Folks,

By default the reporting sort fields seem to be limited by the primary reporting table, is there a way or anything in plan to enable sort by other fields/attributes from other tables referenced via dot walking?

Thanks

Paul

[Petr Eliseev · Accepted solution]

Hi Paul, this might be only true as of New York release and the way is a bit tricky, but here is a way it can be done.

1) Make sure there is a sort in the report, any sort, save

2) Open report from the sys_report table view "https://yourinstance.service-now.com/sys_report_list.do"

3) There will be "Order results by the following fields" section, scroll down on the drop-down and select "Show Related Fields"; from there it is similar to other like navigators.

Hope this helps,

Petr

[dhinrichs]

Thanks!  Confirming this still does what it needs to do as of the Washington release.

[Hines]

You can also switch from the new UI to the Classic UI (at the top of the screen)

[Paul Kendall]

Hi Petr,

This does indeed provide the capability as i'd be expect.

Many thanks for taking the time to reply to this.

Paul