spGetEmailProjectCapWizTransactions
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EmailProjectID | int | IN | |
| @ProjectAppealID | int | IN | |
| @AppealListID | int | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spGetEmailProjectCapWizTransactions]
(@EmailProjectID int,
@ProjectAppealID int,
@AppealListID int) AS
BEGIN
SELECT et.[AlertTitle],
count(et.CapWizTransactionsID) Actions
FROM CapWizTransactions et
INNER JOIN Email e on et.EmailID = e.[ID]
INNER JOIN emailprojectappeal_ListEmail epale on e.ProjectAppealListEmailID = epale.[ID]
INNER JOIN EmailProjectAppeal_EmailList epael on epale.[EmailProjectAppealListID] = epael.[ID]
INNER JOIN EmailProjectAppeal epa on epael.EmailProjectAppealID = epa.[ID]
INNER JOIN EmailProject ep on epa.[EmailProjectID] = ep.[ID]
WHERE (ep.[ID] = @EmailProjectID OR @EmailProjectID = 0) AND (epa.[ID] = @ProjectAppealID OR @ProjectAppealID = 0)
AND (epael.[ID] = @AppealListID OR @AppealListID = 0) AND epael.[AppealListType] = 1
and isdeleted = 0
GROUP BY et.[AlertTitle]
END