Update parent of a child kb article if parent version is outdated.

[Gopal6]

Hi,

I have an requirement where the parent of child kb article should be updated to published version of parent kb article when parent kb article version is outdated. How can I achieve this?

Thanks,

Gopal 

[Gunjan Kiratkar]

Hi @Gopal6 

I think that is OOB available in instance as per below thread:-

https://www.servicenow.com/community/knowledge-managers/the-parent-field-on-the-child-article-is-get... 

[jaheerhattiwale]

@Gopal6 Enable "Knowledge Management Advanced Installer" plugin if not already installed. This will activate the versioning on articles.

Please write below Business Rule on kb_knowledge table

Script:

(function executeRule(current, previous /*null when async*/) {

//Get all the child articles of outdated article
var knowledge = new GlideRecord("kb_knowledge");
knowledge.addQuery("parent="+current.sys_id.toString());
knowledge.query();

while(knowledge.next()){
//Get the last published version of outdated article
var publishedArticle = new GlideRecord("kb_knowledge");
publishedArticle.addQuery("workflow_state=published");
publishedArticle.orderByDesc("sys_updated_on");
publishedArticle.query();

if(publishedArticle.next()){
//If any published version article for outdated article is found the set it as parent of child article
knowledge.parent = publishedArticle.sys_is.toString();
knowledge.update();
}
}

})(current, previous);

Please mark as correct answer if this solves your problem

[Gopal6]

Hi, 

Thanks for the reply. I have tried this but child article still shows outdated parent article. Do u know what is missing here?

[jaheerhattiwale]

@Gopal6 Try below updated code.

(function executeRule(current, previous /*null when async*/) {

//Get all the child articles of outdated article

var knowledge = new GlideRecord("kb_knowledge");

knowledge.addQuery("parent="+current.sys_id.toString());

knowledge.query();

while(knowledge.next()){

//Get the last published version of outdated article

var publishedArticle = new GlideRecord("kb_knowledge");

publishedArticle.addQuery("workflow_state=published");

publishedArticle.addQuery("number="+knowledge.number.toString());

publishedArticle.orderByDesc("sys_updated_on");

publishedArticle.query();

if(publishedArticle.next()){

//If any published version article for outdated article is found the set it as parent of child article

knowledge.parent = publishedArticle.sys_id.toString();

knowledge.update();

}

}

})(current, previous);

Please mark as correct answer if this solves your issue.