Home Analyst Portal

Query for showing activities and information about parent items.

Eivind_OsbakEivind_Osbak Customer Advanced IT Monkey ✭✭✭

Hi.

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]
,[Title]
,[ParentWorkItemId]
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.

/Eivind

Best Answers

Answers

Sign In or Register to comment.