How to query for the latest record in a table?

nehayadav · ‎10-27-2015

Hello,

How can I query for the latest record from a table.

thanks!

bernyalvarado · ‎10-27-2015

Please note that the setLimit(1) will limit the query to only the first record returned by the query and the orderByDesc('sys_created_on') will sort the results based on its created date been the most recent one the first one in the list.

I hope this helps

Thanks,

Berny

View solution in original post

nehayadav · ‎10-28-2015

Thanks Berny! This is exactly what I was looking for.

-Neha

bernyalvarado · ‎10-28-2015

You're welcome!

Lekha · ‎06-14-2021

How can I call this method from report condition builder?

Hari Munagala · ‎01-17-2022

Hi,

How to print my latest 10 incidents by written background script

Aimee Smieth · ‎05-23-2022

Hi Hari,

See changes in bold below for your requirement:

var gr = new GlideRecord ('incident');

gr.orderByDesc('sys_created_on');

gr.setLimit(10);

gr.query();

while (gr.next()){

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

}