V_SEARCH_TEAMFUNDRAISINGTEAM
Search screen for finding team fundraising team records.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| NAME | nvarchar(100) | ||
| GOAL | money | ||
| FULLNAME | nvarchar(1009) | yes | |
| CAPTAINS | nvarchar(max) | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 9/1/2024 11:53:29 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3800.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SEARCH_TEAMFUNDRAISINGTEAM AS
select TEAMFUNDRAISINGTEAM.ID,
TEAMFUNDRAISINGTEAM.NAME,
TEAMFUNDRAISINGTEAM.GOAL,
dbo.UFN_TEAMFUNDRAISINGTEAM_BUILDFULLNAME(TEAMFUNDRAISINGTEAM.ID) FULLNAME,
dbo.UDA_BUILDLIST([CAPTAINCONSTITUENT].NAME) CAPTAINS
from dbo.TEAMFUNDRAISINGTEAM
left join dbo.TEAMFUNDRAISINGTEAM [PARENTTEAM] on TEAMFUNDRAISINGTEAM.PARENTTEAMID = PARENTTEAM.ID
left join dbo.TEAMFUNDRAISINGTEAMCAPTAIN on TEAMFUNDRAISINGTEAM.ID = TEAMFUNDRAISINGTEAMCAPTAIN.TEAMFUNDRAISINGTEAMID
left join dbo.CONSTITUENT [CAPTAINCONSTITUENT] on TEAMFUNDRAISINGTEAMCAPTAIN.CONSTITUENTID = [CAPTAINCONSTITUENT].ID
left join (select distinct [CAPTAINSUMMARYTEAM].ID [TEAMID]
from dbo.TEAMFUNDRAISINGTEAM [CAPTAINSUMMARYTEAM]
left join dbo.TEAMFUNDRAISINGTEAMCAPTAIN [CAPTAINSUMMARYTEAMCAPTAIN] on [CAPTAINSUMMARYTEAM].ID = [CAPTAINSUMMARYTEAMCAPTAIN].TEAMFUNDRAISINGTEAMID
left join dbo.CONSTITUENT [CAPTAINSUMMARYCONSTITUENT] on [CAPTAINSUMMARYTEAMCAPTAIN].CONSTITUENTID = [CAPTAINSUMMARYCONSTITUENT].ID)
[CAPTAINSUMMARY] on TEAMFUNDRAISINGTEAM.ID = [CAPTAINSUMMARY].[TEAMID]
group by TEAMFUNDRAISINGTEAM.ID, TEAMFUNDRAISINGTEAM.NAME, TEAMFUNDRAISINGTEAM.GOAL