Lookup select box sort

[servicenow14710]

Hello developers,

I am using Lookup select box, table used is sc_req_item and reference qualifier is added. 

In dropdown i want to show latest closed records first follwed by old closed ones. I have tried ORDERBY, ORDERBYDESC and even used script include and returing the sysids after sorting...still not able to show in descending order of closed_at field. 

Any suggestions are appreciated, 

Thanks!

Reference qualifiers: javascript:'cat_item=bde6cd8c83f45610662c58dfeeaad34a^u_item_requested_for=88eab9d41b44f51097c1620abb4bcbf3^state=3^variables.2b28c596ebb8d610908cf24e0bd0cd35INadd_user,renew_user^ORDERBYclosed_at' (also tried ORDERBYDESC)

tried without Javascript

cat_item=bde6cd8c83f45610662c58dfeeaad34a^u_item_requested_for=88eab9d41b44f51097c1620abb4bcbf3^state=3^variables.2b28c596ebb8d610908cf24e0bd0cd35INadd_user,renew_user^ORDERBYclosed_at (also tried ORDERBYDESC)

and using script include:

var query = 'cat_item=bde6cd8c83f45610662c58dfeeaad34a^u_item_requested_for=' + user + '^state=3^variables.2b28c596ebb8d610908cf24e0bd0cd35INadd_user,renew_user';

        var grQuery = new GlideRecordSecure('sc_req_item');

        grQuery.addEncodedQuery(query);

        grQuery.orderByDesc('closed_at'); // Sort by Closed_at in descending order

        grQuery.query();

        var sysIds = [];

        while (grQuery.next()) {

            sysIds.push(grQuery.getValue('sys_id'));

        }

        var ret_query = 'sys_idIN' + sysIds.join(',');

        gs.log('return query = ' + ret_query, 'flexim');

        return ret_query;

[Anurag Tripathi]

This feels like a reference qualifier. 

can you add the attribute?

[servicenow14710]

Hello @Anurag Tripathi :

tried this(attached ss), still showing data based on created date (old to new).

Thanks!

[servicenow14710]

Hello @Anurag Tripathi :

tried this (attached ss), still showing data based on created date (old to new).

Thanks!

[Anurag Tripathi]

Did You see this?

Change the sort order of a Lookup Select Box Varia... - ServiceNow Community