UFN_FAF_COMPANYMEMBERLIST
The function takes the constituentID of the company leader and return all participants under that company on all levels
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CONSTITUENTID | uniqueidentifier | IN | |
| @EVENTID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_FAF_COMPANYMEMBERLIST
(
@CONSTITUENTID uniqueidentifier = NULL
,@EVENTID uniqueidentifier = NULL
)
returns @COMPANYMEMBER TABLE
(
TEAMNAME nvarchar(100)
,TEAMID uniqueidentifier
,keyname nvarchar(100)
,name nvarchar(256) NULL
,ID uniqueidentifier
)
AS
BEGIN
DECLARE @TeamID uniqueidentifier
SELECT @TeamID = FNTEAM.TEAMID
FROM dbo.UFN_FAF_GETTEAMINFO_BY_REGISTRANT(@CONSTITUENTID, @EVENTID) FNTEAM
INSERT INTO @COMPANYMEMBER
select
TFT.NAME,
TFT.ID,
C.keyname,
C.name,
C.ID
from dbo.UFN_FAF_GETTEAMHIEARACHY(@TeamID) TH
INNER JOIN dbo.TEAMFUNDRAISINGTEAM TFT
ON TH.TEAMID = TFT.ID
INNER JOIN dbo.TEAMFUNDRAISINGTEAMMEMBER TM
ON TM.TEAMFUNDRAISINGTEAMID = TFT.ID
INNER JOIN dbo.TEAMFUNDRAISER TF
ON TM.TEAMFUNDRAISERID = TF.ID
INNER JOIN dbo.CONSTITUENT C
ON TF.CONSTITUENTID = C.ID
RETURN
END