// -- CODE --
//--copy articles from parent major incident to child incidents
try
{
var childIncIdsArr=[];
var childIncObj={};
var parentKBArtlArr=[];
var childKBArtArr=[];
var newArtArr=[];
var childKBTaskAddGr= new GlideRecord('m2m_kb_task');
//--get the list of articles attached to the parent incident
var m2mKBTaskParentGr = new GlideRecord('m2m_kb_task');
m2mKBTaskParentGr.addQuery('task='+current.sys_id+'');
m2mKBTaskParentGr.query();
while(m2mKBTaskParentGr.next())
{
parentKBArtlArr.push(m2mKBTaskParentGr.kb_knowledge+'');
}
//--get the list of child incident details
var childIncGr= new GlideRecord('incident');
childIncGr.addQuery('parent_incident='+current.sys_id+'');
childIncGr.query();
while(childIncGr.next())
{
childIncIdsArr.push(childIncGr.sys_id+'');
childIncObj[childIncGr.sys_id+'']={};
childIncObj[childIncGr.sys_id+'']['kb_articles']=parentKBArtlArr;
childIncObj[childIncGr.sys_id+'']['inc_state']=childIncGr.state+'';
/*
format used
{
'sys_id of the child incident':{
'kb_articles':[array of kb articles linked to the child incident],
'inc_state':'state of the incident'
}
}
*/
}
//--get the list of articles attached to the parent incident but not present in child incident
var m2mKBTaskChildGr = new GlideRecord('m2m_kb_task');
m2mKBTaskChildGr.addQuery('task.sys_idIN'+childIncIdsArr.join(','));
m2mKBTaskChildGr.query();
while(m2mKBTaskChildGr.next())
{
var childIncArtTempArr=childIncObj[m2mKBTaskChildGr.task+'']['kb_articles'];//array of articles for the child incident
var childArtIndx= childIncArtTempArr.indexOf(m2mKBTaskChildGr.kb_knowledge+'');//index of the article in the array of the child incidents articles
if(childArtIndx>-1)
childIncArtTempArr.splice(childArtIndx,1);//remove the article from child incident object, if the article is already linked
childIncObj[m2mKBTaskChildGr.task+'']['kb_articles']=childIncArtTempArr;
}
//--now insert the articles for the child incident
for(var childIncObjItr in childIncObj)
{
var tempIncObj= childIncObj[childIncObjItr];
var tempIncObjArtlArr=tempIncObj['kb_articles'];
//--dont inherit article if child incident already has articles and incident state is closed
if(tempIncObj['inc_state']=='7' && tempIncObjArtlArr.length>0)
continue;
for(var i=0; i<tempIncObjArtlArr.length;i++)
{
childKBTaskAddGr.newRecord();
childKBTaskAddGr.kb_knowledge=tempIncObjArtlArr[i]+'';//sys id of the kb article
childKBTaskAddGr.task= childIncObjItr+'';//sys id of the child incident
childKBTaskAddGr.insert();
}
}
}
catch(e)
{
gs.log("Error caught in 'Inf Inherit parent articles via incident' Business Rule. Error message: "+e);
}
})
Hi,
I am trying to copy kb articles linked to a parent incident to the child incidents whenever a child incident is linked.
The link between incident and kb articles is maintained in m2m_kb_task table and thus I have written a business rule on incident table to insert m2m_kb_task records.
I have written the below attached code where I am first fetching all the child incidents and then storing the information in below format (object with keys as sys id of the child incident containing another object with 2 elements viz. kb_articles which contains array of sys ids of the kb articles linked with the child incident, and 2nd element as state of child incident):
Step 1:
first storing the articles linked with parent incident inside an array named 'parentKbArtArr'
{
'sys_id of child incident 1': {
'kb_articles':'array of sys ids of kb articles already linked to the child incident', // default value as parentKbArtArr
'inc_state': 'state of the child incident'
}
and so on...
}
I am keeping the default value of the 'kb_articles' array for all the child incidents object as an array of articles linked with the parent incident i.e. parentKbArtArr.
Step 2:
Then I am querying m2m_kb_task table with the task.sys_idIN child incident sys ids, in order to remove the kb articles from the kb_articles array for a child incident, if there is already a link existing.
e.g. {
'inc01': ['parentkb1','parentkb2','parentkb3','parentkb4'],
'inc_state':'2'
}
where inc01 = sys id of child incident and parentkbs are sys ids of the kb articles linked to the parent incidents. now if parent kb2 and parentkb3 are already linked to inc01, I wanted the kb_articles array to contain only parentkb1 and parentkb4.
i.e.
{'inc01': ['parentkb1','parentkb4'],
'inc_state':'2'}
Step 3:
Finally, I will get my modified json and I will iterate it to insert m2m_kb_task records using the child inc sys ids and the array of articles
e.g. the json object might get converted to below
{
'inc01': ['parentkb1','parentkb4'],
'inc_state':'2',
'inc01': [''parentkb2','parentkb3','parentkb4'],
'inc_state':'1'
'inc01': ['parentkb1','parentkb2','parentkb3','parentkb4'],
'inc_state':'2'
'inc01': ['parentkb1','parentkb3','parentkb4'],
'inc_state':'1'
}
PROBLEM STATEMENT:
*****************************
I am getting stuck at the step 2 where I am using splice method to remove an element from the array.
The splice method is somehow modifying the complete array which is reference with all the child incident elements instead of the child incident element which is required.
