UFN_FAFEVENT_GETEVENTEMAILTEMPLATE_TOITEMLISTXML

Used to convert the results of UFN_FAFEVENT_GETEVENTEMAILTEMPLATE to xml.

Return

Return Type
xml

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  3/19/2013 1:17:35 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Based on:  UFN_FAFEVENT_GETEVENTEMAILTEMPLATE
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_FAFEVENT_GETEVENTEMAILTEMPLATE_TOITEMLISTXML](
@EVENTID uniqueidentifier
    )
returns xml
as
BEGIN

RETURN (
 SELECT 
  [CCEMAILADDRESSES],
  [CONTENTHTML],
  [COPYBATCHGUID],
  [COPYSOURCEID],
  [CURRENTSTATUS],
  [DATASOURCEID],
  [DELETED],
  [DESCRIPTION],
  [ENABLED],
  [ETYPECODE],
  [FAFTASKID],
  [FORCOMPLEADER],
  [FORFUNDCOACH],
  [FORHH],
  [FORHHMEMBER],
  [FORINDIVIDUAL],
  [FORSPONSOR],
  [FORTEAMLEADER],
  [FORTEAMMEMBER],
  [FROMADDRESS],
  [FROMDISPLAYNAME],
  [GUID],
  [ID],
  [ISACTIVE],
  [ISDEFAULTFORTASK],
  [NAME],
  [NCNOTIFICATIONID],
  [NOTICATIONDESCRIPTION],
  [NOTICATIONNAME],
  [NOTIFICATIONTYPEID],
  [PREVIOUSSTATUS],
  [PRIORITY],
  [RECIPIENTCOMPLEADER],
  [RECIPIENTDONOR],
  [RECIPIENTHHLEADER],
  [RECIPIENTHHMEMBER],
  [RECIPIENTINDIVIDUAL],
  [RECIPIENTPROSPECT],
  [RECIPIENTTEAMLEADER],
  [RECIPIENTTEAMMEMBER],
  [REPLYADDRESS],
  [SUBJECT],
  [TYPE]
 FROM dbo.[UFN_FAFEVENT_GETEVENTEMAILTEMPLATE](@EVENTID)
 for xml path('ITEM'),type,elements,root('EVENTEMAILTEMPLATES'),BINARY BASE64

)

END