USP_DATALIST_CONSTITUENTNAMEFORMATS

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 
                (
                    @CONSTITUENTID uniqueidentifier,
                    @CURRENTAPPUSERID uniqueidentifier,
                    @SITEFILTERMODE tinyint = 0,
                    @SITESSELECTED xml = null
                )
                as
                    set nocount on;

                    select
                        NAMEFORMATTYPECODE.DESCRIPTION,
                        NAMEFORMAT.FORMATTEDNAME,
                        NAMEFORMAT.SEQUENCE,
                        NAMEFORMAT.PRIMARYADDRESSEE,
                        NAMEFORMAT.PRIMARYSALUTATION,
                        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 
                        (@SITEFILTERMODE = 0 or 
                        NAMEFORMAT.SITEID in (select 
                                        SITEID
                                    from 
                                        dbo.UFN_SITE_BUILDDATALISTSITEFILTER (@CURRENTAPPUSERID, @SITEFILTERMODE, @SITESSELECTED)
                                    )
                        )
                    order by
                        SEQUENCE;