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.

[Ankur Bawiskar]

@Satya Yadav 

Hope you are doing good.

Did you get a chance to check on the solution provided to resolve your query?

If your query is resolved please my response as correct & helpful so that this thread can be closed and others can be benefited by this.

Regards
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.number);
}

[Himanshu Gupta1 · Accepted solution]

HI,

Please find the below script for getting last 10 records.

var incRecord = new GlideRecord('incident');
incRecord.orderByDesc('sys_created_on');
incRecord.setLimit(10);
incRecord.query();
while(incRecord.next()){
gs.info("Incident Record: " + incRecord.number);

}

Please mark this helpful if your query is resolved

Best Regards

Himanshu 

[EricG]

Can this also be written as an Encoded Query or UI Macro?

[EricG]

I got that to work, but how do you translate that over to a UI Macro?