GlideRecord orderBy is not working

[yauheni_karasiu]

GlideRecord method orderBy is not working on sysapproval table if we use dot-walking as an argument in orderBy. See screenshot.

[yauheni_karasiu]

it's not working even if I use sysapproval.request.requested_for.name

Best Regards, Yauheni.
ServiceNow Support.

[Ashutosh Munot1]

HI,

I tried same scenario long back ago. Dot walk in order by does not work.

Thank you,

Ashutosh Munot

[yauheni_karasiu]

Hi Ashutosh,

It's strange, because orderBy with dot-walking is working on incident table. See below. Records has been sorted by last name.

Thank you.

[Ashutosh Munot1]

HI,

Ohk.

So now in your query try

sysapproval.request.number

Thank you,

Ashutosh Munot

[yauheni_karasiu]

Hi,

The same issue. See below.

Thank you.