1 ACCEPTED SOLUTION
you can use onLoad catalog client script + GlideAjax which runs on sc_task and sc_req_item
that will check if the 2nd task is closed or not
Script Include: It should be client callable
var YourScriptIncludeName = Class.create();
YourScriptIncludeName.prototype = Object.extendsObject(AbstractAjaxProcessor, {
checkPreviousTaskClosed: function() {
var recordId = this.getParameter('sysparm_record_id');
var table = this.getParameter('sysparm_table');
var parent = null;
// Determine parent (RITM) based on table
if (table === 'sc_req_item') {
parent = recordId;
} else if (table === 'sc_task') {
var task = new GlideRecord('sc_task');
if (task.get(recordId)) {
parent = task.request_item;
} else {
return 'false';
}
} else {
return 'false';
}
// Get all tasks for the parent and check if the previous "Agreed date completed" task is closed
var tasks = new GlideRecord('sc_task');
tasks.addQuery('request_item', parent);
tasks.orderBy('sys_created_on');
tasks.query();
var foundCurrent = false;
while (tasks.next()) {
if (table === 'sc_task' && tasks.sys_id == recordId) {
foundCurrent = true;
continue;
}
if (!foundCurrent) {
if (tasks.short_description == 'Agreed date completed' && tasks.state == '3') {
return 'true';
}
}
}
return 'false';
},
type: 'YourScriptIncludeName'
});
onLoad Catalog Client Script: Which Applies on Applies on Catalog Tasks = True and Applies on Requested Items = True
function onLoad() {
var table = g_form.getTableName();
var recordId = g_form.getUniqueValue();
var ga = new GlideAjax('YourScriptIncludeName');
ga.addParam('sysparm_name', 'checkPreviousTaskClosed');
ga.addParam('sysparm_record_id', recordId);
ga.addParam('sysparm_table', table);
ga.getXML(function(response) {
var answer = response.responseXML.documentElement.getAttribute("answer");
if (answer === 'true') {
g_form.setVariablesReadOnly(true);
}
});
}💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏
