Parent Child Involvements Report

This script runs from the Main Reports Menu if added to the Menu (Administration > Setup > Special Content > Text Content > CustomReportsMenu). It shows any Involvement that is either a parent or child of another Involvement.

The recommended name is ParentChildInvolvements

Use the following code to Create the SQL Script. See How to create a SQL Script.

SELECT  ParentOrgId = p.OrganizationId
       ,ParentOrg = p.OrganizationName
       ,ChildOrgId = c.OrganizationId
       ,ChildOrg = c.OrganizationName
FROM    dbo.Organizations c
JOIN dbo.Organizations p ON p.OrganizationId = c.ParentOrgId
ORDER BY ParentOrg, ChildOrg


Latest Update 10/18/2021

Update terminology for Involvements