USP_DATALIST_ACTIONITEMDELIVERYDETAILS

Action item delivery details data list.

Parameters

Parameter	Parameter Type	Mode	Description
@CONTEXTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



create procedure dbo.USP_DATALIST_ACTIONITEMDELIVERYDETAILS(@CONTEXTID uniqueidentifier)
as
    set nocount on;

  Declare @CONSTITUENTID  uniqueidentifier
  Declare @ActionItemID  uniqueidentifier

  Select @CONSTITUENTID  = CONSTITUENTID, @ActionItemID = ActionItemID
    From dbo.ADVOCACYACTIVITY (NOLOCK) WHERE ID = @CONTEXTID

    select ID,
           TARGETNAME,
       [TYPE] As DeliveryType,
       DISTRICT,
       DISTRICTNAME,
       [STATUS] As MessageStatus
    from dbo.ADVOCACYLOG (nolock) 
    where CONSTITUENTID  = @CONSTITUENTID and ActionItemID = @ActionItemID