USP_DATALIST_EMAILADDRESS

This datalist returns all email addresses for a constituent.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



            CREATE procedure dbo.USP_DATALIST_EMAILADDRESS (@CONSTITUENTID uniqueidentifier)
            as
                set nocount on;

                select
                    EMAILADDRESS.ID,
                    EMAILADDRESS.EMAILADDRESS,
                    dbo.UFN_EMAILADDRESSTYPECODE_GETDESCRIPTION(EMAILADDRESS.EMAILADDRESSTYPECODEID) as TYPE,
                    EMAILADDRESS.ISPRIMARY,
                    --case when EMAILADDRESS.DONOTEMAIL=0 then '' else 'RES:warning' end,

                    case when EMAILADDRESS.DONOTEMAIL=0 then '' else 'Do not email' end,
                    dbo.UFN_INFOSOURCECODE_GETDESCRIPTION(EMAILADDRESS.INFOSOURCECODEID) as INFOSOURCE,
                    EMAILADDRESS.INFOSOURCECOMMENTS,
                    EMAILADDRESS.EMAILADDRESSTYPECODEID,
                    EMAILADDRESS.DONOTEMAIL,
                    EMAILADDRESS.STARTDATE,
                    EMAILADDRESS.ENDDATE
                from
                    dbo.EMAILADDRESS
                where
                    EMAILADDRESS.CONSTITUENTID = @CONSTITUENTID and
                    (EMAILADDRESS.ENDDATE is null or EMAILADDRESS.ENDDATE > convert(date, getdate()))
                order by
                    EMAILADDRESS.ISPRIMARY desc, TYPE;