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.