UFN_CONSTITUENTINTERACTION_GETSITELIST

Returns a comma delimited list of sites associated with the given constituent interaction.

Return

Return Type
nvarchar(1024)

Parameters

Parameter	Parameter Type	Mode	Description
@INTERACTIONID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_CONSTITUENTINTERACTION_GETSITELIST(
                @INTERACTIONID uniqueidentifier
            )
            returns nvarchar(1024)
            as
            begin
                declare @SITES nvarchar(1024) = (select dbo.UDA_BUILDLIST(SITE.NAME)
                    from dbo.UFN_CONSTITUENTINTERACTION_GETSITES(@INTERACTIONID) INTERACTIONSITE
                        inner join dbo.SITE on SITE.ID = INTERACTIONSITE.SITEID
                );

                return @SITES;            
            end