How do I sort by reference field in a GlideRecord?

[stephen_tharp]

I am attempting to sort a GlideRecord query against he Sys_User table by the Manager field. I know this is because it's a reference field, but I'm having trouble with the syntax. Can anyone help me sort this query by the manager name or userid?

var names = new GlideRecord('sys_user');
names.addQuery('user_name', 'IN', varName);
names.orderBy('manager');

[MrMuhammad · Accepted solution]

Please use names.orderBy('manager.name');

Please mark this ACCEPTED & HELPFUL if applicable. Thanks!

[MrMuhammad]

Sample code I tried. 

var gr = new GlideRecord('sys_user');
gr.addQuery('active', true);
gr.orderBy('manager.name');
gr.query();

while(gr.next()){
 if(gr.manager.name)
   gs.print(gr.manager.name);
}

OUTPUT