Sorting via Dot walked fields

Paul Kendall · ‎11-19-2018

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 · ‎01-15-2020

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

View solution in original post

Alberto Consonn · ‎11-19-2018

Hi Paul,

yes it's possible, please read this useful documentation, it will help you a lot:

Selecting fields on related tables using dot-walking

There are some examples as well that might help you in doing it.

Enjoy 🙂

Please, remember to mark Correct or Helpful if you find my response useful.

Cheers
Alberto

Paul Kendall · ‎11-19-2018

Thanks for the reply although this isn't quiet what I'm looking for, I'm aware on how to select fields from related tables via dot walking.

What I'd actually like to know is how to be able to Sort a reports on a field values from a related table.

Phonsie Hevey1 · ‎05-30-2019

Hi Paul,

Did you ever figure out a way to do this? I just came across this issue now and found this question.

Kind regards,

Phonsie

Paul4 · ‎06-05-2019

Hey Phonsie,

Nope this is still not possible to my knowledge, i guess a Db view would provide the capability in bespoke instances, but is not driving capability of end user reporting.

Regards

Paul