V_QUERY_CAMPAIGNFUNDRAISER
Provides the ability to query campaign fundraisers.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| CAMPAIGNID | uniqueidentifier | Campaign ID | |
| CONSTITUENTID | uniqueidentifier | Constituent ID | |
| CAMPAIGNFUNDRAISERPOSITIONCODE | nvarchar(100) | yes | Campaign position |
| CAMPAIGNFUNDRAISERTASKCODE | nvarchar(100) | yes | Task |
| FUNDRAISERNAME | nvarchar(154) | yes | Fundraiser name |
| SITENAME | int | yes | Site |
| 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 | |
| TSLONG | bigint | yes | Timestamp value |
| POSITIONID | uniqueidentifier | yes | Position ID |
| DATEFROM | datetime | yes | Start date |
| DATETO | datetime | yes | End date |
| STATUS | varchar(7) | Status |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/17/2011 2:35:41 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_CAMPAIGNFUNDRAISER AS
select
CAMPAIGNFUNDRAISER.ID,
CAMPAIGNFUNDRAISER.CAMPAIGNID,
CAMPAIGNFUNDRAISER.CONSTITUENTID,
CAMPAIGNFUNDRAISERPOSITIONCODE.DESCRIPTION as CAMPAIGNFUNDRAISERPOSITIONCODE,
CAMPAIGNFUNDRAISERTASKCODE.DESCRIPTION as CAMPAIGNFUNDRAISERTASKCODE,
CONSTITUENT.NAME as FUNDRAISERNAME,
-- AdamBu - Bug 25283 - Pull sites from the constituent record, not org position.
-- AdamBu - Bug 25283 - Design change: Not site value at this level.
null SITENAME,
[ADDEDBY].APPLICATIONNAME as [ADDEDBY_APPLICATION],
[ADDEDBY].USERNAME as [ADDEDBY_USERNAME],
[CHANGEDBY].APPLICATIONNAME as [CHANGEDBY_APPLICATION],
[CHANGEDBY].USERNAME as [CHANGEDBY_USERNAME],
CAMPAIGNFUNDRAISER.DATEADDED,
CAMPAIGNFUNDRAISER.DATECHANGED,
CAMPAIGNFUNDRAISER.TSLONG,
ORGANIZATIONPOSITIONHOLDER.POSITIONID,
CAMPAIGNFUNDRAISER.DATEFROM,
CAMPAIGNFUNDRAISER.DATETO,
CAMPAIGNFUNDRAISER.STATUS
/*#EXTENSION*/
from
dbo.CAMPAIGNFUNDRAISER
left join dbo.CONSTITUENT on CAMPAIGNFUNDRAISER.CONSTITUENTID = CONSTITUENT.ID
left join dbo.CAMPAIGNFUNDRAISERPOSITIONCODE on CAMPAIGNFUNDRAISER.CAMPAIGNFUNDRAISERPOSITIONCODEID = CAMPAIGNFUNDRAISERPOSITIONCODE.ID
left join dbo.CAMPAIGNFUNDRAISERTASKCODE on CAMPAIGNFUNDRAISER.CAMPAIGNFUNDRAISERTASKCODEID = CAMPAIGNFUNDRAISERTASKCODE.ID
left join dbo.CHANGEAGENT as [ADDEDBY] on ADDEDBY.ID = CAMPAIGNFUNDRAISER.ADDEDBYID
left join dbo.CHANGEAGENT as [CHANGEDBY] on CHANGEDBY.ID = CAMPAIGNFUNDRAISER.CHANGEDBYID
-- AdamBu - Bug 25283 - Since we are now pulling the site from the constituent record, there's no more need for these joins.
-- AdamBu - Bug 25283 - Design change: Adding a node for the fundraiser's current position, so join to get its ID.
left join dbo.ORGANIZATIONPOSITIONHOLDER
on ORGANIZATIONPOSITIONHOLDER.CONSTITUENTID = CONSTITUENT.ID
and [ORGANIZATIONPOSITIONHOLDER].DATETO is null