USP_GETCOUNTSBYACTIONITEMID

Get Count of Actions Taken and Messages sent for a given activity in action center

Parameters

Parameter	Parameter Type	Mode
@ACTIONITEMID	uniqueidentifier	IN
@SITECONTENTID	int	IN
@ACTIONSTAKEN	int	INOUT
@MESSAGESSENT	int	INOUT

Definition

Copy



create procedure dbo.USP_GETCOUNTSBYACTIONITEMID(@ACTIONITEMID uniqueidentifier, @SITECONTENTID int,
        @ACTIONSTAKEN INT OUTPUT, @MESSAGESSENT INT OUTPUT)WITH EXECUTE AS CALLER
as
begin
    SET @ACTIONSTAKEN = (
        SELECT COUNT(*) 
        FROM dbo.ADVOCACYACTIVITY 
        WHERE ACTIONITEMID = @ACTIONITEMID
        AND SITECONTENTID = @SITECONTENTID )

    SET @MESSAGESSENT = 
    (
        SELECT COUNT(*)
        FROM dbo.ADVOCACYLOG 
        WHERE ACTIONITEMID = @ACTIONITEMID 
        AND SITECONTENTID = @SITECONTENTID 
        AND [STATUS] = 'Delivered'
    )
end