1 ACCEPTED SOLUTION
1) create classless script include like this
function getRecords() {
var ritmSysIds = []; // Array to store matching RITM sys_ids
var ritm = new GlideRecord('sc_req_item');
ritm.query(); // Add filters: ritm.addQuery('active', true);
while (ritm.next()) {
var hasCoreClosed = false;
var hasApprovalOpen = false;
var task = new GlideRecord('sc_task');
task.addQuery('request_item', ritm.sys_id);
task.query();
while (task.next()) {
var desc = task.short_description.toString();
if (desc.startsWith('Core') && task.state == 7) {
hasCoreClosed = true;
}
if (desc.startsWith('Approval') && task.state != 7) {
hasApprovalOpen = true;
}
}
if (hasCoreClosed && hasApprovalOpen) {
ritmSysIds.push(ritm.sys_id.toString());
}
}
return ritmSysIds.toString();
}
2) then call like this Sys ID [IS ONE OF] javascript: getRecords();
💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏
