Home Analyst Portal

How do I view the number of incidents related to a given knowledge article?

chrisrutledgechrisrutledge Member IT Monkey ✭
edited March 2018 in Analyst Portal
We want our "Featured Article" articles to be the ones with the most incidents related to them. I haven't been successful in finding this data in the Knowledge Manager Dashboard, Advanced Search, or in any of the three exported .csv files I've found (KnowledgeArticle$Comment.csv, KnowledgeArticle$Rating.csv, KnowledgeArticle.csv).

Where is this information located?

Best Answer

  • Adam_DzyackyAdam_Dzyacky Product Owner Contributor Monkey ✭✭✭✭✭
    edited March 2018 Answer ✓
    If I'm not mistaken, the WorkItem$KnowledgeArticle table keeps the relationship between Work Items and Knowledge Articles.

    However as far as setting the Featured Article dynamically based on this aforementioned dataset, it sounds like a custom Stored Procedure you'd have to wire up to modify the KnowledgeArticle table.

Answers

  • Adam_DzyackyAdam_Dzyacky Product Owner Contributor Monkey ✭✭✭✭✭
    edited March 2018 Answer ✓
    If I'm not mistaken, the WorkItem$KnowledgeArticle table keeps the relationship between Work Items and Knowledge Articles.

    However as far as setting the Featured Article dynamically based on this aforementioned dataset, it sounds like a custom Stored Procedure you'd have to wire up to modify the KnowledgeArticle table.
  • chrisrutledgechrisrutledge Member IT Monkey ✭
    Thanks, Adam!
Sign In or Register to comment.