UFN_BUILDSTEPPARTICIPANTSLIST

Returns a string holding the list of participants associated with the given step.

Return

Return Type
nvarchar(max)

Parameters

Parameter	Parameter Type	Mode	Description
@INTERACTIONID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_BUILDSTEPPARTICIPANTSLIST
            (
                @INTERACTIONID uniqueidentifier
            )
            returns nvarchar(max)
            with execute as caller
            as begin                
                declare @OUTPUT nvarchar(max);

                select
                    @OUTPUT = dbo.UDA_BUILDLIST(NF.NAME)
                from dbo.INTERACTIONPARTICIPANT
                    cross apply dbo.UFN_CONSTITUENT_DISPLAYNAME(INTERACTIONPARTICIPANT.CONSTITUENTID) NF
                where INTERACTIONID = @INTERACTIONID;

                return @OUTPUT;
            end