UFN_FAFADDRESSBOOK_ALLCONTACTS_LIST

Get the List of all contacts from FAF address book

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN
@CLIENTUSERID	int	IN

Definition

Copy



CREATE FUNCTION [dbo].[UFN_FAFADDRESSBOOK_ALLCONTACTS_LIST]
(
     @EVENTID        AS uniqueidentifier
    ,@CLIENTUSERID    AS INT
)
RETURNS TABLE
AS
RETURN
    WITH 
    [FAFADDRESSBOOKCONTACTS]
    AS
    (
        SELECT   A.ID AS CONTACTID
                ,A.FIRSTNAME
                ,A.LASTNAME
                ,CASE 
                    WHEN D.CONSTITUENTID IS NOT NULL THEN 1 
                    ELSE 0                     
                END AS [ISDONOR]
                ,CASE 
                    WHEN TM.CONSTITUENTID IS NOT NULL THEN 1
                    ELSE 0                    
                END AS [ISTEAMMEMBER]
                ,CASE WHEN D.STATUS IS NULL THEN 'N/A' ELSE D.STATUS END AS DONORSTATUS
                ,CASE WHEN TM.STATUS IS NULL THEN 'N/A' ELSE TM.STATUS END AS TEAMSTATUS
        FROM    [dbo].[ADDRESSBOOKFAF] A (NOLOCK)
        LEFT    JOIN [dbo].[UFN_FAFADDRESSBOOK_TEAMMEMBERS_LIST](@EVENTID,@CLIENTUSERID) TM        
        ON        A.CONSTITUENTID = TM.CONSTITUENTID                             
        LEFT    JOIN [dbo].UFN_FAFADDRESSBOOK_DONORS_LIST(@EVENTID,@CLIENTUSERID) D        
        ON        A.CONSTITUENTID = D.CONSTITUENTID    
        WHERE   A.CLIENTUSERSID in (select CLIENTUSERID from dbo.UFN_CLIENTUSERS_GETIDLISTBYCURRENTCLIENTUSERID(@CLIENTUSERID)) 
    )
    SELECT * FROM  [FAFADDRESSBOOKCONTACTS];