UFN_COMMUNICATIONLETTER_GETEXCLUDEDSELECTIONS

Retrieve the selections to be excluded from a given communication letter.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@COMMUNICATIONLETTERID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_COMMUNICATIONLETTER_GETEXCLUDEDSELECTIONS
(
    @COMMUNICATIONLETTERID uniqueidentifier
)
returns table as
    return (
        select
            COMMUNICATIONLETTERSELECTION.ID,
            COMMUNICATIONLETTERSELECTION.IDSETREGISTERID as SELECTIONID,
            IDSETREGISTER.NAME
        from dbo.COMMUNICATIONLETTERSELECTION    
        inner join dbo.IDSETREGISTER
            on COMMUNICATIONLETTERSELECTION.IDSETREGISTERID = IDSETREGISTER.ID
        where COMMUNICATIONLETTERID = @COMMUNICATIONLETTERID
            and FILTERTYPECODE = 1
)