V_QUERY_CAMPAIGN
Provides the ability to query campaigns.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| USERID | nvarchar(100) | Lookup ID | |
| NAME | nvarchar(100) | Name | |
| DESCRIPTION | nvarchar(300) | Description | |
| CAMPAIGNTYPECODEDESCRIPTION | nvarchar(100) | yes | Type |
| STARTDATE | date | yes | Start date |
| ENDDATE | date | yes | End date |
| PARENTCAMPAIGNID | uniqueidentifier | yes | Parent campaign system record ID |
| ADDEDBY_APPLICATION | nvarchar(200) | yes | Added by application |
| ADDEDBY_USERNAME | nvarchar(128) | yes | Added by user name |
| CHANGEDBY_APPLICATION | nvarchar(200) | yes | Changed by application |
| CHANGEDBY_USERNAME | nvarchar(128) | yes | Changed by user name |
| DATEADDED | datetime | Date added | |
| DATECHANGED | datetime | Date changed | |
| ISACTIVE | bit | Active | |
| PATH | nvarchar(1000) | yes | Path |
| BASECURRENCYID | uniqueidentifier | yes | Base currency |
| CAMPAIGNTYPECODEID | uniqueidentifier | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 9/30/2015 1:01:49 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.153.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_CAMPAIGN AS
select
CAMPAIGN.ID,
CAMPAIGN.USERID,
CAMPAIGN.NAME,
CAMPAIGN.DESCRIPTION,
CAMPAIGNTYPECODE.DESCRIPTION as [CAMPAIGNTYPECODEDESCRIPTION],
CAMPAIGN.STARTDATE,
CAMPAIGN.ENDDATE,
(select PARENTCAMPAIGN.ID from dbo.CAMPAIGN as [PARENTCAMPAIGN] where CAMPAIGN.HIERARCHYPATH.GetAncestor(1) = PARENTCAMPAIGN.HIERARCHYPATH) as [PARENTCAMPAIGNID],
ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
ADDEDBY.USERNAME as ADDEDBY_USERNAME,
CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
CHANGEDBY.USERNAME as CHANGEDBY_USERNAME,
CAMPAIGN.DATEADDED,
CAMPAIGN.DATECHANGED,
CAMPAIGN.ISACTIVE,
dbo.UFN_CAMPAIGN_GETPATH(CAMPAIGN.ID) PATH,
CAMPAIGN.BASECURRENCYID,
[CAMPAIGN].[CAMPAIGNTYPECODEID]
/*#EXTENSION*/
from dbo.CAMPAIGN
left outer join dbo.CAMPAIGNTYPECODE on CAMPAIGN.CAMPAIGNTYPECODEID = CAMPAIGNTYPECODE.ID
left outer join dbo.CHANGEAGENT as ADDEDBY on CAMPAIGN.ADDEDBYID = ADDEDBY.ID
left outer join dbo.CHANGEAGENT as CHANGEDBY on CAMPAIGN.CHANGEDBYID = CHANGEDBY.ID