Has anyone dot walked within an OrderBy command?

[Chad27]

Hello,

I am trying to order by a field on a record I'm referencing within a function. The field cmdb_ci_service is a reference field on the task_cmdb_ci_service table but I want to order by a field that is on the cmdb_ci_service record. Has anyone successfully done this? Doesn't seem to be working for me. Below is a code snippet from my script. This works if I want to order by the cmdb_ci_service but won't work when dot walking and trying to order by to the u_business_service_tier. 

insertBS();

function insertBS() {
var ubus = new GlideRecord('task_cmdb_ci_service');
ubus.addQuery('task', current.sys_id);
ubus.orderBy('cmdb_ci_service.u_business_service_tier');
ubus.query();

Any suggestions? 

Thanks in advance.

[vkachineni]

What kind of field is u_business_service_tier?

The following works on incident

var ubus = new GlideRecord('incident');
ubus.orderBy('caller_id.company.name');
ubus.query();
while(ubus.next())
{
gs.info(ubus.caller_id.company.name + "****" + ubus.number );
}

[Chad27]

u_business_service_tier is just a string field (drop down) with 4 choices. (tier_a, tier_b, tier_c, tier_d). 

[vkachineni]

Try with an encoded query

var ubus = new GlideRecord('incident');
ubus.addEncodedQuery('ORDERBYcaller_id.time_zone');
ubus.query();
while(ubus.next())
{
gs.info(ubus.number + " ** " + ubus.caller_id.name + " ** " + ubus.caller_id.time_zone);
}

[Chad27]

Unfortunately I received the same results using the encoded query. Seems like there has to be a way to do this, straightforward situation.