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]

Hi,

Can you try Variable attributes: "ref_ac_order_by=<field you want it to be sorted by>"

[servicenow14710]

Hello @Anurag Tripathi : Thanks for you quick reply i tried this already and it didnt work. 

it works for ORDERBY  ascending , but  not for descending . Thanks!

[Anurag Tripathi]

Can you show what you have tried? and the expected outcome?

[servicenow14710]

Hello @Anurag Tripathi :

javascript&colon;'cat_item=bde6cd8c83f45610662c58dfeeaad34a^u_item_requested_for=88eab9d41b44f51097c1620abb4bcbf3^state=3^variables.2b28c596ebb8d610908cf24e0bd0cd35INadd_user,renew_user^ORDERBYclosed_at' - 

tried this - expected output should be latest closed should be first, but it was at end of dropdown.

Thanks!