We have a script include which is called in the UI Action " Resolve Incident ", where we check if the incident is child of any other incident or if the incident has any dependent task to be completed or to check if any change solves this particular incident. If any of these conditions are met then throw an alert that there is an dependency.
Where as we are able to check the dependency individually by querying it , but when we query it with OR condition it is not working as expected. Kindly let me know where is it going wrong? Any other way to implement it.
When i try each one of these independently it works fine..
RelType.addQuery('name', 'Depends on::Dependent for');
//RelType.addQuery('name', 'Solved by::Solves');
//RelType.addQuery('name', 'Parent Of::Child Of');
But when i combine these with OR condition it doesn't work:
RelType.addQuery('name', 'Depends on::Dependent for').addOrCondition('name', 'Solved by::Solves');
Script include:
var corOpenDependencies = Class.create();
corOpenDependencies.prototype = Object.extendsObject(AbstractAjaxProcessor, {
OpenDependencies: function() {
var sysID = this.getParameter('sysparm_sysid');
var flag = 'false';
var ParentSysID;
var ParentSysID1;
var answer1 = "false";
//gs.log(answer, 'answer');
var answer2;
/////////////////////////////////////////////////////////
// Get the object for the 'Depend on' Relationship type.
/////////////////////////////////////////////////////////
var RelType = new GlideRecord('task_rel_type');
RelType.addQuery('name', 'Depends on::Dependent for');
//RelType.addQuery('name', 'Solved by::Solves');
//RelType.addQuery('name', 'Parent Of::Child Of');
//RelType.addQuery('name', 'Depends on::Dependent for').addOrCondition('name', 'Solved by::Solves');
RelType.query();
///////////////////////////////////////////////////
// Only proceed if the relationship types exists.
// Check for both the relationships.
///////////////////////////////////////////////////
while (RelType.next()) {
////////////////////////////////////////////////////
// Set the default value of the parent relationship
// to look for. We start with the SYSID passed in.
////////////////////////////////////////////////////
ParentSysID = sysID;
}
////////////////////////////////////////////////////////////////
// Search for all related records that this record
// is related to as a child and using the 'Depends On'
// relationship.
////////////////////////////////////////////////////////////////
var Rel = new GlideRecord('task_rel_task');
Rel.addQuery('parent', ParentSysID);
Rel.addQuery('type', RelType.sys_id);
Rel.addQuery('child.active', true);
Rel.query();
var req;
while (Rel.next()) {
flag= "true";
req=Rel.child;
//gs.log(req,'n');
var ReqTask = new GlideRecord('sc_task');
ReqTask.get('request_item.request', Rel.child);
if(ReqTask.state!='6' && ReqTask.state!='3'){
answer1 = "true";
}
}
if(flag == "true" && answer1 == "true")
{
answer2 = "true";
}
else
{
answer2 = "false";
}
//gs.log(answer2,'ammy');
return answer2;
},
type: 'corOpenDependencies'
});
