V_SEARCHLIST_EVENT2
Search screen for event records.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| LOOKUPID | nvarchar(100) | yes | |
| AltLookupID | nvarchar(100) | yes | |
| NAME | nvarchar(100) | ||
| STARTDATE | date | ||
| ENDDATE | date | ||
| LOCATION | nvarchar(100) | yes | |
| CONTACT | nvarchar(154) | yes | |
| SITE | nvarchar(250) | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 3/19/2013 1:31:29 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SEARCHLIST_EVENT2 AS
select [EVENT].ID,
[EVENT].LOOKUPID,
[EVENTEXTENSION].LOOKUPEVENTID as AltLookupID,
[EVENT].NAME,
[EVENT].STARTDATE,
[EVENT].ENDDATE,
[EVENTLOCATION].NAME LOCATION,
CONSTITUENT.NAME CONTACT,
[SITE].NAME SITE
from dbo.[EVENT]
left join dbo.[EVENTEXTENSION] on [EVENT].ID = [EVENTEXTENSION].EVENTID
left join dbo.EVENTLOCATION on [EVENT].EVENTLOCATIONID = EVENTLOCATION.ID
left join dbo.CONSTITUENT on [EVENT].EVENTLOCATIONCONTACTID = CONSTITUENT.ID
left join dbo.EVENTSITE on EVENTSITE.EVENTID = EVENT.ID
left join dbo.[SITE] on [EVENTSITE].SITEID = [SITE].ID;