how to get the last 10 records in incident table?

[SN27]

Hi All,

I wanted to get last 10 records in incident table through background script.

Please help me out here.

Thanks & Regards,

sAtyA.

[Daniel Biesiada]

Try below script: 

var inc = new GlideRecord('incident');

inc.setLimit(10);

inc.orderByDesc('sys_created_on');

inc.query();
while(inc.next()){

}

[Ankur Bawiskar]

Hi Satya,

if you want last 10 records which got updated then use this

try{

var incRec = new GlideRecord('incident');
incRec.orderByDesc('sys_updated_on');

// if you want last 10 records which are created then use orderByDesc('sys_created_on')

incRec.setLimit(10);
incRec.query();
while(incRec.next()){

// do processing

}

}
catch(ex){
gs.info('Exception is: ' + ex);
}

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Ankur Bawiskar]

@Satya Yadav 

Hope you are doing good.

Did my reply answer your question?

If so, please mark appropriate response as correct & helpful so that the question will appear as resolved for others who may have a similar question in the future.

Thanks!
Ankur

[PRASHANTH KUMAR]

try this code;

display business rule

var inc = new GlideRecord('incident');
inc.setLimit(10);
inc.orderByDesc('number');
inc.query();
while(inc.next())
{
gs.addInfoMessage("last 10 records #" + inc.category);
}