USP_DATALIST_COMMUNICATIONLETTER

Returns a list of letters associated with a given communication.

Parameters

Parameter	Parameter Type	Mode	Description
@SEGMENTATIONID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@CHANNELCODE	tinyint	IN	Send via

Definition

Copy



CREATE procedure dbo.USP_DATALIST_COMMUNICATIONLETTER
(
    @SEGMENTATIONID uniqueidentifier,
    @CHANNELCODE tinyint = null
)
as
    set nocount on;

    select    
        SEGMENTATIONID,
        COMMUNICATIONLETTERID as ID,
        SEQUENCE,
        NAME,
        CHANNEL,
        MAILCONTENTDEFINED,
        EMAILCONTENTDEFINED,
        MOVEUP_ENABLED,
        MOVEDOWN_ENABLED,
        REMOVE_ENABLED
    from dbo.UFN_DATALIST_COMMUNICATIONLETTERS(@SEGMENTATIONID, @CHANNELCODE);