V_SEARCHLIST_EVENT
Search screen for event records.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| NAME | nvarchar(100) | ||
| STARTDATE | date | ||
| ENDDATE | date | ||
| LOCATION | nvarchar(100) | yes | |
| CONTACT | nvarchar(154) | yes | |
| SITE | nvarchar(250) | yes | |
| ROOM | nvarchar(100) | yes | |
| LOOKUPID | nvarchar(100) | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 9/1/2024 11:52:46 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3800.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SEARCHLIST_EVENT AS
select
[EVENT].[ID],
[EVENT].[NAME],
[EVENT].[STARTDATE],
[EVENT].[ENDDATE],
[EVENTLOCATION].[NAME] as [LOCATION],
[CONSTITUENT].[NAME] as [CONTACT],
[SITE].[NAME] as [SITE],
[EVENTLOCATIONROOM].[NAME] as [ROOM],
[EVENT].[LOOKUPID]
from dbo.[EVENT]
left join dbo.[EVENTLOCATION] on [EVENT].[EVENTLOCATIONID] = [EVENTLOCATION].[ID]
left join dbo.[EVENTLOCATIONROOM] on [EVENT].[EVENTLOCATIONROOMID] = [EVENTLOCATIONROOM].[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];