USP_DATALIST_CONSTITUENTNAMEFORMATS_1_1

This datalist returns all of the name formats for a constituent.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SITEFILTERMODE	tinyint	IN	Sites
@SITESSELECTED	xml	IN

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_CONSTITUENTNAMEFORMATS_1_1 
                (
                    @CONSTITUENTID uniqueidentifier,
                    @CURRENTAPPUSERID uniqueidentifier,
                    @SITEFILTERMODE tinyint = 0,
                    @SITESSELECTED xml = null
                )
                as
                    set nocount on;

                    select
                        NAMEFORMAT.FORMATTEDNAME,
                        NAMEFORMATTYPECODE.DESCRIPTION,
                        NAMEFORMAT.SEQUENCE,
                        NAMEFORMAT.PRIMARYADDRESSEE,
                        NAMEFORMAT.PRIMARYSALUTATION,
                        NAMEFORMAT.ID,
                        isnull((select NAME from dbo.SITE where SITE.ID = NAMEFORMAT.SITEID),'') as SITENAME
                    from
                        dbo.NAMEFORMAT 
                        left join dbo.NAMEFORMATTYPECODE on NAMEFORMATTYPECODE.ID = NAMEFORMAT.NAMEFORMATTYPECODEID
                    where
                        NAMEFORMAT.CONSTITUENTID = @CONSTITUENTID 
              and (dbo.UFN_SITEALLOWEDFORUSER(@CURRENTAPPUSERID, SITEID) = 1 or SITEID is null) --null site means all sites, so anyone should be able to see it

                            and (
                                @SITEFILTERMODE = 0
                                    or exists(
                                    select 1
                                    from dbo.UFN_SITE_BUILDDATALISTSITEFILTER (@CURRENTAPPUSERID, @SITEFILTERMODE, @SITESSELECTED) SITEFILTER
                                    where NAMEFORMAT.SITEID = SITEFILTER.SITEID
                                    )
                            )

                    order by
                        SEQUENCE;