Home Service Manager Portal Feature Requests
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 Known Issue column to dbo.workitem

Brian_WiestBrian_Wiest Customer Super IT Monkey ✭✭✭✭✭
Working on SQL chart widgets for the enterprise. but the Cache builder table does not contain Known Issue as a target. Looking for something similar to IsParent with a 0 or 1 value. This will allow the widgets to display known issues vs other problems. 
6 votes

Submitted · Last Updated


  • Options
    Geoff_RossGeoff_Ross Cireson Consultant O.G.
    Hi Brian,

    Like the idea. Until this gets upvoted enough, you can Join to your ServiceManager SQL DB and use the data from there.

    SELECT WI.WorkItemId [Id]
    FROM WorkItem [WI]
    JOIN [ServiceManager].[dbo].[MTV_System$WorkItem$Problem] [Problem]
    ON Problem.BaseManagedEntityId = WI.Id
    WHERE Problem.KnownError_4CE16CF0_5098_3CBD_3F72_72C2C5201FDB = 1

  • Options
    Brian_WiestBrian_Wiest Customer Super IT Monkey ✭✭✭✭✭
    Perfect, Thanks
Sign In or Register to comment.