V_QUERY_SUBEVENT
Query view that pulls each event's sub-events.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| PARENTEVENTID | uniqueidentifier | Parent event ID | |
| ID | uniqueidentifier | System record ID | |
| LEVEL | smallint | yes | Level |
| LEVELNAME | nvarchar(100) | yes | Level name |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/17/2011 2:36:00 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_SUBEVENT AS
select
EVENT.ID PARENTEVENTID,
CHILDEVENTS.ID,
CHILDEVENTS.HIERARCHYPATH.GetLevel() LEVEL,
coalesce(EVENTMANAGEMENTLEVELINSTANCE.NAME, '') LEVELNAME
from
dbo.EVENT
inner join dbo.EVENTHIERARCHY PARENTEVENT on PARENTEVENT.ID = EVENT.ID
inner join dbo.EVENTHIERARCHY CHILDEVENTS on CHILDEVENTS.HIERARCHYPATH.IsDescendantOf(PARENTEVENT.HIERARCHYPATH) = 1 and CHILDEVENTS.ID <> PARENTEVENT.ID
inner join dbo.EVENTMANAGEMENTOPTIONS on EVENTMANAGEMENTOPTIONS.EVENTID = CHILDEVENTS.ID
left outer join dbo.EVENTMANAGEMENTLEVELINSTANCE on EVENTMANAGEMENTLEVELINSTANCE.ID = EVENTMANAGEMENTOPTIONS.EVENTMANAGEMENTLEVELINSTANCEID