How to get first 10 Active records in incident table

[Harsha varma]

Hi am new to ServiceNow please help to code

[Musab Rasheed]

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]

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]

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]

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.