USP_DATAFORMTEMPLATE_VIEW_PETITIONDETAILPROFILE

The load procedure used by the view dataform template "Petition Detail Profile 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.
@ACTIONITEMNAME	nvarchar(500)	INOUT	Action item name
@ACTIONCENTERNAME	nvarchar(512)	INOUT	Action item center
@SIGNATURENUMBER	int	INOUT	Signature number
@DATE	nvarchar(10)	INOUT	Date
@ACTIONITEMTYPE	nvarchar(16)	INOUT	Action item type
@FEDERALDISTRICTCODE	nvarchar(8)	INOUT	Federal state district code
@UPPERSTATEDISTRICTCODE	nvarchar(10)	INOUT	Upper state district code
@LOWERSTATEDISTRICTCODE	nvarchar(10)	INOUT	Lower state district code
@ACTIONTYPECODE	tinyint	INOUT	Action type code

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PETITIONDETAILPROFILE
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
  @ACTIONITEMNAME nvarchar(500) = null output,
    @ACTIONCENTERNAME nvarchar(512) = null output,
  @SIGNATURENUMBER int = null output,
    @DATE nvarchar(10) = null output,
  @ACTIONITEMTYPE nvarchar(16) = null output,
  @FEDERALDISTRICTCODE nvarchar(8) = null output,
  @UPPERSTATEDISTRICTCODE nvarchar(10) = null output,
  @LOWERSTATEDISTRICTCODE nvarchar(10) = null output,
  @ACTIONTYPECODE tinyint = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select top 1
    @DATALOADED = 1,
      @ACTIONITEMNAME = AI.NAME,
      @ACTIONCENTERNAME = SC.Title,
      @SIGNATURENUMBER = AIP.PETITIONCOUNT,
      @DATE = Convert(varchar, AA.DATEADDED, 101),
      @ACTIONITEMTYPE = AI.TYPE,
      @FEDERALDISTRICTCODE = AP.FEDERALDISTRICTCODE,
      @UPPERSTATEDISTRICTCODE = AP.UPPERSTATEDISTRICTCODE,
      @LOWERSTATEDISTRICTCODE = AP.LOWERSTATEDISTRICTCODE,
    @ACTIONTYPECODE = AI.TYPECODE
  from dbo.ADVOCACYACTIVITY (Nolock) AA
    Inner Join dbo.ACTION_ITEM (nolock) AI On AA.ACTIONITEMID = AI.ID
    Inner Join dbo.SiteContent (nolock) SC On AA.SiteContentID = SC.ID
    Inner join dbo.ADVOCACYPetition (nolock) AP on AP.ConstituentID=AA.ConstituentID 
          and AP.ACTIONITEMID = AA.ACTIONITEMID
    Inner join dbo.ACTIONITEMPETITION AIP (NOLOCK) on AIP.ACTIONITEMID = AI.ID
  where AA.ID=@ID

    return 0;