USP_DATALIST_EMAILBODAY
Returns Email Body data
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CONSTITUENTID | uniqueidentifier | IN | Constituent ID |
| @EVENTID | uniqueidentifier | IN | Event ID |
| @CONFIRMATIONTYPECODE | tinyint | IN | Confirmation Type Code |
| @REVENUEID | uniqueidentifier | IN | Revenue ID |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_EMAILBODAY(
@CONSTITUENTID uniqueidentifier=null,
@EVENTID uniqueidentifier=null,
@CONFIRMATIONTYPECODE tinyint=1,
@REVENUEID uniqueidentifier=null
)
as
set nocount on;
if @REVENUEID is not null
begin
select EJE.EMAILBODY from EMAILJOBEXTENSION EJE
inner join EMAILJOB EJ on ej.ID=eje.EMAILJOBID
inner join emailtemplate ET ON ET.ID=EJ.EmailTemplateID
inner join EVENTEMAILTEMPLATE EET on EET.EMAILTEMPLATEID=ET.ID and EET.EVENTID=EET.EVENTID and CONFIRMATIONTYPECODE in (1,2,3)
where REVENUEID=@REVENUEID
end
else
begin
select top 1 EJE.EMAILBODY
from EMAILJOBEXTENSION EJE
inner join EmailJob EJ on EJ.ID=EJE.EMAILJOBID
--INNER JOIN EmailTemplate ET ON ET.ID=EJ.EmailTemplateID
inner join EVENTEMAILTEMPLATE EET on EET.EMAILTEMPLATEID=EJ.EmailTemplateID
where EJE.CONSTITUENTID=@CONSTITUENTID
and EJE.EVENTID=@EVENTID
and EET.CONFIRMATIONTYPECODE=@CONFIRMATIONTYPECODE
order by EJE.DATEADDED desc
end