how to get the last 10 records in incident table

tom_lundy · ‎07-10-2017

I am trying to do a get call to retrieve the latest 10 records in a incident table.

Harsh Vardhan · ‎07-10-2017

Hi Tom,

setLimit(): Sets the limit for how many records you want to fetch.

var c=0;

var check= new GlideRecord('incident');

check.addQuery('category','software');

check.setLimit(10);

check.query();

while(check.next())

{

c++

gs.print('check the :'+check.number);

}

gs.print('total nnumber of record is:'+c);

OUTPUT

Shishir Srivast · ‎07-20-2017

Does orderByAsc() worked for you?

bmd6793 · ‎09-03-2017

Hi Shishir,

yes, i have modified the code and it gives result as number by descending order.

Output:

Code:

var c=0;

var gr= new GlideRecord('incident');

gr.orderByDesc('sys_created_on');

gr.setLimit(10);

gr.query();

while(gr.next())

{

c++

gs.print('check the :'+gr.number);

}

gs.print('total number of record is:'+c);

Arvind Kumar1 · ‎08-23-2022

var gr = new GlideRecord('incident');

gr.orderBy('number');
gr.setLimit(10);
gr.query();
while(gr.next())
{
gs.print(gr.number);
}

Chiranjeevi K · ‎01-08-2024

Can any one let me know what change should be done to print last 10 records of the current logged in user .