USP_DATAFORMTEMPLATE_VIEW_PETITIONDETAIL

The load procedure used by the view dataform template "Petition detail view form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@ACTIONITEMSTATUS	nvarchar(16)	INOUT	Action item status
@STARTDATE	datetime	INOUT	Action item initiation date
@ENDDATE	datetime	INOUT	Action item expiration date
@STARTCOUNT	int	INOUT	First signature number
@GOAL	int	INOUT	Petition goal
@DEADLINEDATE	nvarchar(400)	INOUT	Petition deadline date

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PETITIONDETAIL
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @ACTIONITEMSTATUS nvarchar(16) = null output,
    @STARTDATE datetime = null output,
    @ENDDATE datetime = null output,
  @STARTCOUNT int = null output,
  @GOAL int = null output,
  @DEADLINEDATE nvarchar(400) = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select @DATALOADED = 1,
           @ACTIONITEMSTATUS = AI.STATUS,
       @STARTDATE = AI.STARTDATE,
       @ENDDATE = AI.ENDDATE,
       @STARTCOUNT = AIP.STARTCOUNT,
       @GOAL = AIP.GOAL,
       @DEADLINEDATE = AIP.DEADLINEDATE
    from dbo.ADVOCACYACTIVITY (NOLOCK) AA
    Inner Join ACTION_ITEM AI on AA.ACTIONITEMID = AI.ID
    Inner Join ACTIONITEMPETITION AIP on AIP.ACTIONITEMID = AA.ACTIONITEMID
    where AA.ID = @ID

    return 0;