Accessing the last record in GlideCollection

[rajanmurkut]

Using 'gr.next()' reads the first record in a glide_collection . But if I want to stat reading the records in reverse order (ie. reading the last record, first) how do I do that? Any suggestion will be appreciated. Thanks.

[sachin_namjoshi]

You need to use orderByDesc() like below

var gr = new GlideRecord ('incident');

gr.orderByDesc('sys_created_on');

gr.setLimit(1);

gr.query();

if (gr.next()){

  gs.print (gr.number + ' - ' + gr.sys_created_on);

}

Regards,

sachin

[sachin_namjoshi · Accepted solution]

You need to use orderByDesc() like below

var gr = new GlideRecord ('incident');


gr.orderByDesc('sys_created_on');


gr.setLimit(1);


gr.query();


if (gr.next()){


   gs.print (gr.number + ' - ' + gr.sys_created_on);


}

Regards,
sachin

[Cody Smith _ Cl]

Before your query add 

gr.orderByDesc('sys_created_on');

Doc to OrderBy

If my answer was helpful, or solved your issue, please mark it as Helpful / Correct.

Thanks,

Cody

[asifnoor]

Hi,

Simply use orderByDesc in your code. here is the sample code to refer.

var gr = new GlideRecord('incident');

gr.orderByDesc(‘number');

gr.query();

if (gr.next()) {

  gs.info("Number is" +gr.number);

}

Mark the answer as correct or helpful if this helps.