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,

I tried in my instance and it is sorting out by descending order. Can you check it

var m = new GlideRecord('sysapproval_approver');

m.addQuery('sysapproval.sys_class_name=sc_req_item');

m.setLimit(100);

m.orderByDesc('sysapproval');

m.query();

while(m.next())

{

gs.print(m.getDisplayValue('sysapproval.request'));

}

[yauheni_karasiu]

Vinoth,

You are ordering just by "sysapproval", the issue if you use dot-walking, for example "sysapproval.request".

Thank you.

[Kannan Nadar]

Hi,

"sysapproval" field is referencing the task table. Can you try the below.

gr.orderByDesc('sysapproval.number')

[yauheni_karasiu]

Hi,

Yes, it's wokring with "sysapproval.number", but I need to sort by field request on the requested item and it's not working again, see screenshot below.