USP_DATALIST_CONSTITUENTPROFILEDASHBOARDNAMEFORMATS

This datalist returns a constituent's name formats that are used by the constituent profile dashboard.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Constituent ID
@ISVISIBLE	bit	IN	Is visible
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



                    CREATE procedure dbo.USP_DATALIST_CONSTITUENTPROFILEDASHBOARDNAMEFORMATS
                    (
                        @CONSTITUENTID uniqueidentifier,
                        @ISVISIBLE bit = 1,
                        @CURRENTAPPUSERID uniqueidentifier
                    )
                    as
                        set nocount on;

                        if @ISVISIBLE = 1
                        begin
                            select
                                NF.FORMATTEDNAME,
                                NFTC.DESCRIPTION as TYPE,
                                NF.PRIMARYADDRESSEE,
                                NF.PRIMARYSALUTATION,
                                coalesce(SITE.NAME, 'All sites') as SITE
                            from
                                dbo.NAMEFORMAT NF
                                left join dbo.NAMEFORMATTYPECODE NFTC on NFTC.ID = NF.NAMEFORMATTYPECODEID
                                left join dbo.SITE on NF.SITEID = SITE.ID
                            where
                                NF.CONSTITUENTID = @CONSTITUENTID
                                and (
                                    NF.SITEID is null or
                                    dbo.UFN_SITEALLOWEDFORUSER(@CURRENTAPPUSERID, NF.SITEID) = 1    
                                )
                            order by
                                NF.SEQUENCE;                            
                        end