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
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
Update terminology for Involvements