getting the case number from the incident record

[Sathiskumar_D]

Hello,

I would like to get the status of case (opened , closed at, opened by etc) from related list in incident. .

var grCase=new GlideRecord('incident');
grCase.addEncodedQuery('^RLQUERYsn_customerservice_case.incident,>=1^stateNOT IN6,3,7^ENDRLQUERY');
grCase.addQuery('sys_id','<sys_id of the record>' );
grCase.query();
gs.info(grCase.getRowCount());
while(grCase.next()){
	for (var key in grCase) {
			gs.info('Attribute Name : '+key +' Value : '+grCase[key]);
}
}

Any help is greatly appreciated. Thanks 

[Vishal Jaswal · Accepted solution]

Hello @Sathiskumar_D 

Your Code modified:

var grCase = new GlideRecord('incident');
grCase.addEncodedQuery('^RLQUERYsn_customerservice_case.incident,>=1^stateNOT IN6,3,7^ENDRLQUERY');
grCase.addQuery('sys_id', 'e02a7a6b877313003c1c8467a7cb0bd5');
grCase.query();
gs.info(grCase.getRowCount());
while (grCase.next()) {
    var grCase1 = new GlideRecord('sn_customerservice_case');
    grCase1.addQuery('incident', 'e02a7a6b877313003c1c8467a7cb0bd5');
    grCase1.query();
    while (grCase1.next()) {
        for (var key in grCase1) {
            gs.info('Attribute Name : ' + key + ' Value : ' + grCase1[key]);
        }
    }
}

Screenshot:

Enhanced Code which can be leveraged as fix script to be run via scheduled job:

var grCase = new GlideRecord('incident');
grCase.addEncodedQuery('^RLQUERYsn_customerservice_case.incident,>=1^stateNOT IN6,3,7^ENDRLQUERY');
grCase.query();
gs.info("No. of INCs found: " + grCase.getRowCount());
while (grCase.next()) {
    var grCase1 = new GlideRecord('sn_customerservice_case');
    grCase1.addQuery('incident', grCase.sys_id); // Pass the sys_id dynamically
    grCase1.query();
    while (grCase1.next()) {
        for (var key in grCase1) {
            gs.info('Attribute Name: ' + key + ' Value: ' + grCase1[key]);
        }
    }
}

Screenshot: