Glide record

soniya patil
Tera Contributor

How to print 5 active incident tickets

6 REPLIES 6

Aniket Chavan
Tera Sage
Tera Sage

Hello @soniya patil 

Please refer the background script below:

 

// Create a new GlideRecord for the Incident table
var incidentGR = new GlideRecord('incident');

// Add a condition to filter active incidents
incidentGR.addQuery('active', true);

//This will sort the data by descending order for created field so that you can get the latest 5 INC records
incidentGR.orderByDesc("sys_created_on");

// Limit the result to 5 records
incidentGR.setLimit(5);

// Execute the query
incidentGR.query();

// Loop through the results and print relevant information
while (incidentGR.next()) {
    gs.info('Incident Number: ' + incidentGR.number + ', Short Description: ' + incidentGR.short_description);
}

 


Please modify the query as per your requirement or let me know if you need any help.

Let me know your views on this and Mark Correct if this solves your query and also mark 👍Helpful if you find my response worthy based on the impact.

 

Regards,

Aniket

Sagar Pagar
Tera Patron

Hi @soniya patil,

 

Take a look at old thread. It will help you.

How to get first 10 Active records in incident table 

how to get the last 10 records in incident table 

 

If my response helps you resolve your issue. Kindly mark it as helpful & correct. It will be helpful to future readers! 👍🏻
Thanks,
Sagar Pagar

The world works with ServiceNow

Harish KM
Kilo Patron
Kilo Patron

Hi @soniya patil The below script will print active 5 incidents by order created on

var inc = new GlideRecord('incident');
inc.addActiveQuery();//only active incidents
inc.orderBy('sys_created_on'); // order by created on
inc.setLimit(5); // set limit 5 since needed only 5 incidents
inc.query();
while(inc.next())
{
gs.info("Incident "+inc.number);
}

Regards
Harish

Utpal Dutta
Tera Guru

Hi Soniya,

Below is the script:

var grIncident = new GlideRecord('incident');
grIncident.addQuery('active', true);
grIncident.setLimit(5);
grIncident.query();

while(grIncident.next()){
gs.print(grIncident.getValue('number')); // This will print Incident number when you run it in BG script
}

 

If my script helps then please mark it Correct.

 

Thanks,

Utpal