How to sort advanced reference qualifier for a reference field?

[Bharati Paidiap]

I am using a script include for reference qualifier, but now the list should be sorted . Is there any way this can be achieved?

[chetan1742]

Can you provide your script include code?

[Voona Rohila]

Hi 

You can use orderByDesc/orderBy to sort the

gr.orderByDesc('field_name'); //descending order

gr.orderBy('field_name'); //ascending order

Example:

var gr = new GlideRecord('incident');

gr.orderBy('number');     

gr.orderBy('sys_created_on');//ascending order by created date.

gr.query();

[Bharati Paidiap]

Am not really glide recording anything rather just returning an encoded query.

return 'u_category=' + current.u_case_number.u_dispatch.u_category + '^u_field_name=u_billableratecardcategory' + '^u_mapping_type=Value' + '^u_active=true'+'^ORDERBYu_label';

[Voona Rohila]

Looks like orderby is already added, Is it not working?

return 'u_category=' + current.u_case_number.u_dispatch.u_category + '^u_field_name=u_billableratecardcategory' + '^u_mapping_type=Value' + '^u_active=true^ORDERBYu_label';