Home Analyst Portal

Query for showing activities and information about parent items.

Eivind_OsbakEivind_Osbak Customer Advanced IT Monkey ✭✭✭


I'm creating a dashboard for displaying information about activities and its parent workitems.
I've created a very basic query to display all manual activities:

SELECT [WorkItemId]
FROM [ServiceManagement].[dbo].[WorkItem]
Where [ClassId] like '7AC62BD4-8FCE-A150-3B40-16A39A61383D'

I would like to get information like the title of its parent items, and also the parents parentitem. In this case because the MAs parent is a CR and the CRs parent is a RR.

Im not that experienced in SQL queries and hope someone can help me with a query for this so i can later manipulate it to get the data i want.


Best Answers


Sign In or Register to comment.