How to get first 10 Active records in incident table

Harsha varma
Kilo Explorer

Hi am new to ServiceNow please help to code

8 REPLIES 8

Musab Rasheed
Kilo Patron

Hi Harsha,

Please find the code.

var grI=new GlideRecord("incident");
grI.addActiveQuery();
grI.orderByDesc("sys_created_on");
grI.setLimit(10);
grI.query();
while(grI.next())
{
    gs.info(grI.getDisplayValue());
}

Mark my answer as correct or hit like based on impact.

manu7867
Tera Contributor

hi please try this

var gr = new GlideRecord('incident');
gr.addQuery('active','true');
gr.orderByDesc('sys_created_on');
gr.setLimit(10);
gr.query();
while(gr.next())
{
gs.log("The active records:"+ gr.number);}

manu7867
Tera Contributor

var gr = new GlideRecord('incident');
gr.addQuery('active','true');
gr.orderByDesc('sys_created_on');
gr.setLimit(10);
gr.query();
while(gr.next())
{
gs.log("The active recprds"+ :gr.number);}

Vaibhav_K
Tera Contributor
var gr = new GlideRecord('incident');
//gr.addActiveQuery();
gr.addQuery('active','true');
gr.setLimit('10');
gr.orderByDesc('sys_created_on')
gr.query();
while(gr.next())
{
    //gs.print(gr.number);
    gs.info(gr.getDisplayValue());
}
 
Please mark it helpful if it's really helpful.