USP_SIMPLEDATALIST_MEMBERNAMEFORMATS

Returns a list of all formatted names for a given constituent.

Parameters

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

Definition

Copy



            CREATE procedure dbo.USP_SIMPLEDATALIST_MEMBERNAMEFORMATS
                (
                    @CONSTITUENTID uniqueidentifier,
                    @CURRENTAPPUSERID uniqueidentifier
                )
                as
                    set nocount on;

                    declare @ISORG bit;
                    select @ISORG = ISORGANIZATION from dbo.CONSTITUENT where ID = @CONSTITUENTID;

                    if @ISORG = 0
                        select CONSTITUENT.ID as VALUE,
                            NAME as LABEL
                        from dbo.CONSTITUENT
                        where 
                            ID = @CONSTITUENTID

                        union all

                        select NAMEFORMAT.ID as VALUE,
                            FORMATTEDNAME as LABEL
                        from dbo.NAMEFORMAT 
                        inner join dbo.CONSTITUENT on 
                            CONSTITUENT.ID = NAMEFORMAT.CONSTITUENTID
                        where 
                            CONSTITUENTID = @CONSTITUENTID and
                            (NAMEFORMAT.SITEID is null or dbo.UFN_SITEALLOWEDFORUSER(@CURRENTAPPUSERID, NAMEFORMAT.SITEID) = 1) and
                            NAMEFORMAT.FORMATTEDNAME <> CONSTITUENT.NAME;
                    else
                        select ID as VALUE,
                            NAME as LABEL
                        from dbo.CONSTITUENT
                        where 
                            ID = @CONSTITUENTID;