We are trying to pull the report from kb_knowledge table for a specific Knowledge Base which does not have translated articles related to it. We checked in the relationships table & found the below code. However, we are unable to modify to only fetch the parent KB articles. Please let us know how to proceed on this.
The OOTB SI script is as below:
var KBTranslationSNC = Class.create();
KBTranslationSNC.prototype = {
initialize: function() {
},
/**
* returns encoded query for getting translated version of given article .
*
* @param GlideRecord: kb_knowledge record.
*/
getTranslatedVersionEncodedQuery: function(articleGr){
var kbArticleGr = new GlideRecord('kb_knowledge');
if (new KBCommon().isVersioningInstalled() && !articleGr.summary.nil()){
//Versioning is installed and this article is versioned.
if (gs.nil(articleGr.parent)){
kbArticleGr.addQuery('parent',articleGr.sys_id)
.addOrCondition('parent.summary', articleGr.summary);
}
else {
kbArticleGr.addQuery('summary', '!=', articleGr.summary);
//Bypass Before query BRs for dotwalking.
var temp = new GlideRecord('kb_knowledge');
temp.setWorkflow(false);
temp.get(articleGr.parent);
kbArticleGr.addQuery('parent',articleGr.parent).addOrCondition('parent.summary',articleGr.summary).addOrCondition('summary', temp.summary);
}
}
else {
if (gs.nil(articleGr.parent))
kbArticleGr.addQuery('parent', articleGr.sys_id);
else {
kbArticleGr.addQuery('sys_id', '!=', articleGr.sys_id);
kbArticleGr.addQuery('parent', articleGr.parent).addOrCondition('sys_id', articleGr.parent);
}
}
return kbArticleGr.getEncodedQuery()+'';
},
/**
* returns true if the artcile has any translated version.
*
* @param GlideRecord: kb_knowledge record.
*/
hasTranslatedVersion: function(articleGr){
var kbArticleGr = new GlideRecord('kb_knowledge');
var encodedQuery = this.getTranslatedVersionEncodedQuery(articleGr);
kbArticleGr.addEncodedQuery(encodedQuery);
kbArticleGr.query();
if(kbArticleGr.hasNext())
return true;
return false;
},
type: 'KBTranslationSNC'
};
