V_SEARCH_CAMPAIGN

Search screen for finding a campaign.

Fields

Field	Field Type	Null
ID	uniqueidentifier
NAME	nvarchar(100)
TYPEDESCRIPTION	nvarchar(100)	yes
USERID	nvarchar(100)
SITENAME	nvarchar(250)	yes

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  9/1/2024 11:54:00 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3800.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SEARCH_CAMPAIGN AS



                select 
                    CAMPAIGN.ID,
                    CAMPAIGN.NAME,
                    CAMPAIGNTYPECODE.DESCRIPTION as TYPEDESCRIPTION,
                    CAMPAIGN.USERID,
                    SITE.NAME as SITENAME
                from 
                    dbo.CAMPAIGN
                    left outer join dbo.CAMPAIGNTYPECODE on CAMPAIGN.CAMPAIGNTYPECODEID = CAMPAIGNTYPECODE.ID
                    left outer join dbo.CAMPAIGNSITE on CAMPAIGNSITE.CAMPAIGNID = CAMPAIGN.ID
                    left outer join dbo.SITE on CAMPAIGNSITE.SITEID = SITE.ID;