USP_DATALIST_ALIASES

This datalist returns all aliases 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_ALIASES (@CONSTITUENTID uniqueidentifier)
                as
                    set nocount on;

                    select
                        ALIAS.[ID],
                        ALIAS.[KEYNAME],
                        ALIAS.[NAME],
                        ALIASTYPECODE.[DESCRIPTION] as TYPE
                    from
                        dbo.[ALIAS]
                    left join
                        dbo.[ALIASTYPECODE]
                    on
                        ALIASTYPECODE.[ID] = ALIAS.[ALIASTYPECODEID]
                    where
                        ALIAS.[CONSTITUENTID] = @CONSTITUENTID
                    order by
                        [KEYNAME], [NAME];