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.

[Frank1975]

Hi Yauheni,

i guess since the request field is a reference, its sorting by SysID rather then the number.

thanks

Frank

[yauheni_karasiu]

Frank,

If i use sysapproval.request.number I will face with the same issue. See screenshot below.

Thank you!

[Ashutosh Munot1]

See below code worked for me:

var gr = new GlideRecord('sysapproval_approver');

gr.setLimit(100);

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

gr.OrderBy('sysapproval.request.number');

gr.query();

while(gr.next())

{

  gs.log('Number '+gr.sysapproval.request.number);

}

Thank you,

Ashutosh Munot

Please Hit Correct, Helpful or like,if you are satisfied with this response.

[yauheni_karasiu]

Ashutosh,

Does it really worked for you? Because for me it doesn't, see screenshot. I just copied your code and pasted to xplore.

[Ashutosh Munot1]

Same Problem i faced initially. For reference fields its not working but string it works fine.

Debugging into this.

Thank you,

Ashutosh munot