- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-01-2023 04:46 AM
I created a couple of knowledge base articles linked to a certain configuration item.
When I now open this CI in the CMDB, I would expect that the linked KB articles are shown somewhere here...but I cannot find them. Does anybody know how to see them?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-01-2023 04:59 AM
Hi @Ulrich Schulte ,
There is no Existing relationship exists as what you are looking at.
However, Knowledge articles are related to configuration items using m2m_kb_ci table
Here is the custom relationship you can define using
System Definition > Relationships
and in query with use the below script
(function refineQuery(current, parent) {
// Add your code here, such as current.addQuery(field, value);
current.addQuery('cmdb_ci', parent.sys_id);
current.addQuery('kb_knowledge.workflow_state', '!=', 'retired');
current.addQuery('kb_knowledge.u_approval', '!=', 'Rejected');
})(current, parent);
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-01-2023 04:59 AM
Hi @Ulrich Schulte ,
There is no Existing relationship exists as what you are looking at.
However, Knowledge articles are related to configuration items using m2m_kb_ci table
Here is the custom relationship you can define using
System Definition > Relationships
and in query with use the below script
(function refineQuery(current, parent) {
// Add your code here, such as current.addQuery(field, value);
current.addQuery('cmdb_ci', parent.sys_id);
current.addQuery('kb_knowledge.workflow_state', '!=', 'retired');
current.addQuery('kb_knowledge.u_approval', '!=', 'Rejected');
})(current, parent);
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-01-2023 06:03 AM
Fair enough...but what I don't understand is "no Existing relationship exists".
What I did at my KB Article is this (see screenshot below)...so wouldn't it make sense, that this KB article would show up at the CI "Oracle EU" somewhere instead of the need to look up any other table or define relationships? Why does the field "configuration item" exist on a KB article, if it does not create a relationship?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-01-2023 06:37 AM
Hi @Ulrich Schulte ,
Just having a field on a form doesn't means it would cerate a relationship automatically.