UFN_COMMUNICATION_GETLETTERS_TOITEMLISTXML

Used to convert the results of UFN_COMMUNICATION_GETLETTERS to xml.

Return

Return Type
xml

Parameters

Parameter	Parameter Type	Mode	Description
@COMMUNICATIONID	uniqueidentifier	IN
@COMMUNICATIONTYPECODE	tinyint	IN

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  3/19/2013 1:42:42 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Based on:  UFN_COMMUNICATION_GETLETTERS
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_COMMUNICATION_GETLETTERS_TOITEMLISTXML](
@COMMUNICATIONID uniqueidentifier
, @COMMUNICATIONTYPECODE tinyint
    )
returns xml
as
BEGIN

RETURN (
 SELECT 
  [CHANNELCODE],
  [CHANNELPREFERENCECODE],
  [COMMUNICATIONTYPESXML],
  [EMAILCONTENTHTML],
  [EMAILEXPORTDEFINITIONID],
  [EMAILFROMADDRESS],
  [EMAILFROMDISPLAYNAME],
  [EMAILPACKAGEID],
  [EMAILREPLYTOADDRESS],
  [EMAILSEGMENTID],
  [EMAILSUBJECT],
  [EXCLUDEBASEDONRECENTCOMMUNICATION],
  [EXCLUDEBASEDONRECENTGIVING],
  [EXCLUDEBASEDONTOTALCOMMUNICATIONSINPASTYEAR],
  [EXCLUDEBASEDONTOTALGIVINGINPASTYEAR],
  [EXCLUDEDSELECTIONSXML],
  [EXCLUDEDSOLICITCODESXML],
  [ID],
  [INCLUDEINACTIVE],
  [MAILCONTENTHTML],
  [MAILEXPORTDEFINITIONID],
  [MAILPACKAGEID],
  [MAILSEGMENTID],
  [MARGINBOTTOM],
  [MARGINLEFT],
  [MARGINRIGHT],
  [MARGINTOP],
  [MKTASKLADDERID],
  [NAME],
  [NUMRECENTCOMMUNICATIONPERIODS],
  [NUMRECENTGIVINGPERIODS],
  [NUMTOTALCOMMUNICATIONSINPASTYEAR],
  [OUTPUTTYPECODE],
  [PAPERSIZECODE],
  [RECENTCOMMUNICATIONPERIODTYPECODE],
  [RECENTGIVINGPERIODTYPECODE],
  [RUNNOW],
  [RUNSCHEDULED],
  [SELECTIONSXML],
  [SEQUENCE],
  [TOTALREVENUEAMOUNTINPASTYEAR]
 FROM dbo.[UFN_COMMUNICATION_GETLETTERS](@COMMUNICATIONID, @COMMUNICATIONTYPECODE)
 order by SEQUENCE
 for xml path('ITEM'),type,elements,root('LETTERS'),BINARY BASE64

)

END