How to Retain Relationship between KB Article with Versioning and Custom Table

[Debby Shea Ande]

My company uses the Knowledge module with the Knowledge Management - Advanced plugin installed. This plugin enables versioning among other features.

We use three custom knowledge article templates in addition to the OOB templates.

We have created a basic custom table. We need to be able to show the custom table as a related list in the back-end form of our knowledge articles.

The issue I am running into has to do with versioning. I set up the Related List, and am able to associate a record in the custom table with a knowledge article. This works as expected. However, if the article is checked out, edited and republished, the item from the custom table is no longer displayed in the Related List for that article.

I’ve looked over the table schema for knowledge but admit I’m not able to figure out how to configure the relationship correctly. The goal is to keep the related list entries for each knowledge article persistent from version to version. Thanks!

[Debby Shea Ande]

I created a many-to-many relationship, following this documentation: Create a many-to-many table relationship (servicenow.com). This allowed me to associate KB articles with entries in our custom table.

Then on the form used for entries in our custom table, I added a related list to display KB articles. I added a filter that only shows articles that are in a published state.

Hope this helps!