how to get most recent created incident

[EswarS]

Hi Team,

Can anyone help me  on this

how to get the latest created incident or sctask through scripts

Thanks in advance

[Dr Atul G- LNG · Accepted solution]

Hi @EswarS 

What is the use case you have here? You can do it via list view and sort by created date.

Try this script:

var incidentList = [];

var incident1 = new GlideRecord('incident');

incident1.query();

while(incident1.next()){

    var incident2 = new GlideRecord('incident');

    incident2.orderByDesc('sys_created_on');

    incident2.query();

    if(incident2.next()){

        incidentList.push(incident2.number.toString());

    }

}

var uniqueIncidentList= new ArrayUtil().unique(incidentList);

gs.print(uniqueIncidentList);

I tested this in my PDI and it is working fine.

[OlaN · Accepted solution]

Hi,

Not sure what you want to do with the record you retrieve through the script, but here's something to show how to do.

var latestIncGR = new GlideRecord('incident');
latestIncGR.orderByDesc('sys_created_on');  // sort by created
latestIncGR.setLimit(1);  //only retrieve one record
latestIncGR.query();
if (latestIncGR.next()){
	gs.info('Number: ' + latestIncGR.getValue('number'));
}

[EswarS]

Hi Mimi,
Thank U for the Support 
Ur script worked Fine.