Hi,
Yes, you can add orderBy and ordebydesc clause in gliderecord query.
Refer below, it is working as to sort incidents based on state and desc order for priority:
var gr = new GlideRecord('incident');
gr.orderBy('state'); // Ascending Order
gr.orderByDesc('priority'); // Ascending Order
//gr.addEncodedQuery(queryString);
gr.query();
while (gr.next()) {
gs.info(gr.number+" "+gr.state +" P:"+gr.priority);
}
----Result of above script------
INC Number State(ASC) Priority(DESC)
*** Script: INC0010001 1 P:5
*** Script: INC0010112 1 P:5
*** Script: INC0010111 1 P:5
*** Script: INC0000057 1 P:5
*** Script: INC0000039 1 P:5
*** Script: INC0000058 1 P:5
*** Script: INC0009009 1 P:4
*** Script: INC0007002 1 P:4
*** Script: INC0000046 1 P:3
*** Script: INC0009001 1 P:3
*** Script: INC0000059 1 P:3
*** Script: INC0007001 1 P:1
*** Script: INC0009005 1 P:1
*** Script: INC0000029 2 P:5
*** Script: INC0000020 2 P:5
*** Script: INC0000047 2 P:3
*** Script: INC0000037 2 P:3
*** Script: INC0000041 2 P:3
*** Script: INC0000019 2 P:2
*** Script: INC0000027 2 P:2
*** Script: INC0000049 2 P:2
*** Script: INC0000044 2 P:2
*** Script: INC0000051 2 P:1
*** Script: INC0000055 2 P:1
*** Script: INC0000003 2 P:1
*** Script: INC0000050 2 P:1
*** Script: INC0000052 2 P:1
*** Script: INC0000031 2 P:1
*** Script: INC0000053 2 P:1
*** Script: INC0000018 2 P:1
*** Script: INC0000015 2 P:1
*** Script: INC0000025 2 P:1
Thanks.
