UFN_APPEALMAILINGSETUP_GETLETTERS

Returns all letters associated with a given appeal mailing.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@APPEALMAILINGSETUPID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_APPEALMAILINGSETUP_GETLETTERS
(
    @APPEALMAILINGSETUPID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier
)
returns table as 
    return (
        select
            APPEALMAILINGSETUPLETTER.ID,
            APPEALMAILINGSETUPLETTER.SEQUENCE,
            APPEALMAILINGSETUPLETTER.NAME,
            APPEALMAILINGSETUPLETTER.CHANNELCODE,
            APPEALMAILINGSETUPLETTER.SENDTOOPTIONCODE,
            APPEALMAILINGSETUPLETTER.CONSTITUENTINCLUDECODE,
            APPEALMAILINGSETUPLETTER.CONSIDERREVENUEHISTORY,
            APPEALMAILINGSETUPLETTER.REVENUECRITERIACODE,
            APPEALMAILINGSETUPLETTER.LOWREVENUEAMOUNT,
            APPEALMAILINGSETUPLETTER.HIGHREVENUEAMOUNT,            
            APPEALMAILINGSETUPLETTER.MAILPACKAGEID,
            APPEALMAILINGSETUPLETTER.MAILSEGMENTID,
            APPEALMAILINGSETUPLETTER.EMAILPACKAGEID,
            APPEALMAILINGSETUPLETTER.EMAILSEGMENTID,
            case
                when (CHANNELCODE = 0 or CHANNELCODE = 1) and EMAILSEGMENTID is not null then dbo.UFN_MKTSEGMENT_GETSELECTIONS_TOITEMLISTXML(EMAILSEGMENTID, @CURRENTAPPUSERID)
                when CHANNELCODE = 2 and MAILSEGMENTID is not null then dbo.UFN_MKTSEGMENT_GETSELECTIONS_TOITEMLISTXML(MAILSEGMENTID, @CURRENTAPPUSERID)
            end as SELECTIONS
    --        dbo.UFN_APPEALMAILINGSETUPLETTER_GETSELECTIONS_TOITEMLISTXML(APPEALMAILINGSETUPLETTER.ID) as SELECTIONS

        from dbo.APPEALMAILINGSETUPLETTER
        where APPEALMAILINGSETUPID = @APPEALMAILINGSETUPID
    )