UFN_CONSTITUENTINTERACTION_GETSITES

Given a constituent interaction, retrieves that interaction's list of sites.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@INTERACTIONID	uniqueidentifier	IN

Definition

Copy




            create function dbo.UFN_CONSTITUENTINTERACTION_GETSITES
            (
                @INTERACTIONID uniqueidentifier
            )
            returns table
            as
                return(
                    select
                        ID,
                        SITEID
                    from dbo.INTERACTIONSITE
                    where INTERACTIONSITE.INTERACTIONID = @INTERACTIONID
                        and dbo.UFN_INTERACTION_ISPLANSTEP(INTERACTIONSITE.INTERACTIONID) = 0
                )