We appreciate you taking the time to vote and add your suggestions to make our products awesome! Your request will be submitted to the community for review and inclusion into the backlog.

We recommend reviewing what is submitted before posting, in case your idea has already been submitted by another community member. If it has been submitted, vote for that existing feature request (by clicking the up arrow) to increase its opportunity of being added to Cireson solutions.

For more information around feature requests in the Cireson Community click here.

Add related work items to the knowledgebase.js form

Aaron_BoockAaron_Boock Customer Advanced IT Monkey ✭✭✭
When editing a knowledge article, I'd like to be able to view related work items on the related items tab.  (similar to how related work items are shown for IR and SR).  I understand the challenge of knowledge articles not existing in the SCSM CMDB and only in the ServiceManagement database.
4 votes

Submitted · Last Updated

Comments

  • Chris_StelzerChris_Stelzer Premier Partner IT Monkey ✭
    edited September 2016
    Here's an excellent use of the Dashboard Designer in V6 to get around this! 

    Create a dashboard with a SQL Chart widget and use something like the following as your source, and group by KBID or KB Title.

      SELECT WI.WorkItemID as [Id], WI.Title IRTitle, KA.Title KATitle, WIKA.KnowledgeArticleID, WIKA.CreatedDate
      FROM [dbo].[WorkItem$KnowledgeArticle] WIKA

      JOIN dbo.WorkItem WI
      ON WIKA.WorkItemID = WI.Id

      JOIN dbo.KnowledgeArticle KA
      ON KA.ArticleID = WIKA.KnowledgeArticleID



    Now you can see a nice chart of the MOST referenced KB articles, click on the article in question and see a list of IR's associated with each!
    kb1.png 42.1K
  • Steve_WrightSteve_Wright Cireson Support Advanced IT Monkey ✭✭✭
    Nice Chris!
    Please note for the drill-through of Workitems to work, the field should be aliased as [Id] - for example:
    SELECT WI.WorkItemID as [Id], This is case sensitive and special word in sql validation.

    Thanks,
Sign In or Register to comment.