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.

[vinothkumar]

Hi Yauheni,

There is no field in approval table named request, try modifying it with sysapproval

[yauheni_karasiu]

Hi Vinoth,

There is field "sysapproval", which references to sc_req_item record, which has request field.
I'm ordering by "sysapproval.request".

Thank you.

[Frank1975]

Hi Yauheni,

what if you try

gr.orderByDesc('sysapproval.request')

Thanks

Frank

[yauheni_karasiu]

Hi Frank,

The same issue with gr.orderByDesc, it's not working.

Thank you, Yauheni.