How to remove related articles records from related list in Knowledge article via fix script

[Patiha]

Hi Community,

I have a requirement where all the records that are present in Related Articles(related list) in Knowledge article record to be removed from the related list but should not be deleted from the table, Only remove from related list via a script. I want to achieve this via a fix script. Could someone help me on this.

Thanks in advance!

[Martin Ivanov]

Here we go:

var encodedQuery = 'active=true'; //replace with yours

var grKBArticle = new GlideRecord('kb_knowledge');
grKBArticle.addEncodedQuery(encodedQuery);
grKBArticle.query();

while(grKBArticle.next()){


var grRelated = new GlideRecord('kb_2_kb');
grRelated.addQuery('kb_knowledge', grKBArticle.getUniqueValue());
grRelated.addQuery('related_kb_knowledge.workflow_state', 'retired' )
grRelated.query();

grRelated.deleteMultiple();

}

Please mark Helpful

[Patiha]

Hi @Martin Ivanov ,

Can you tell me where i can check this from, As we are using a custom table for related articles. Like kb_2_kb i replaced with the custom table 'u_knowledge_related'...So if i add the code as below would it work the same...Or I should change the related_kb_knowledge to something else?

related_kb_knowledge.workflow_state

[Martin Ivanov]

This is getting a little bit too far. You had a requirement, you have the answer. basically, you have the logic. Go check your custom table, see how the fields are named there and just adjust my code to work for your custom setup. I have no way, nor the time to, to know how your custom setup does look like.

Thank you!