USP_DATAFORMTEMPLATE_VIEW_ACTIONITEMLETTER

The load procedure used by the view dataform template "Action Item Letter 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.
@ISSUBJECTCHANGED	bit	INOUT	Is subject changed
@ISMESSAGETEXTCHANGED	bit	INOUT	Is message text changed
@FROMADDRESS	nvarchar(510)	INOUT	From address
@TOADDRESS	nvarchar(4000)	INOUT	To address
@SUBJECTLINE	nvarchar(510)	INOUT	Subject line
@SALUTATION	nvarchar(200)	INOUT	Salutation
@MESSAGETEXT	nvarchar(max)	INOUT	Message text
@MESSAGESIGNATURE	nvarchar(510)	INOUT	Message Signature
@ACTIONTYPECODE	tinyint	INOUT	Action item type code

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_ACTIONITEMLETTER
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
  @ISSUBJECTCHANGED bit = null output,
    @ISMESSAGETEXTCHANGED bit = null output,
    @FROMADDRESS nvarchar(510) = null output,
  @TOADDRESS nvarchar(4000) = null output,
  @SUBJECTLINE nvarchar(510) = null output,
  @SALUTATION nvarchar(200) = null output,
  @MESSAGETEXT nvarchar(max) = null output,
  @MESSAGESIGNATURE nvarchar(510) = null output,
  @ACTIONTYPECODE tinyint = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

  Declare @CONSTITUENTID  uniqueidentifier
  Declare @ActionItemID  uniqueidentifier
  Declare @NumTargets int

  Select @CONSTITUENTID  = CONSTITUENTID, @ActionItemID = ActionItemID
    From dbo.ADVOCACYACTIVITY where ID = @ID

  Select @NumTargets = count(ID) from AdvocacyLog (NOLOCK) 
     Where CONSTITUENTID = @CONSTITUENTID 
       and ActionItemID = @ActionItemID


    select top 1 @DATALOADED = 1,
    @ISSUBJECTCHANGED = AL.ISSUBJECTCHANGED,
    @ISMESSAGETEXTCHANGED = AL.ISMESSAGETEXTCHANGED,
    @FROMADDRESS = AL.FROMADDRESS,
    @TOADDRESS = 
         Case When @NumTargets > 1 then 'Multiple targets'
           Else AL.ToAddress
         End,
    @SUBJECTLINE = AL.SUBJECTLINE,
    @SALUTATION = AL.SALUTATION,
    @MESSAGETEXT = AL.MESSAGETEXT,
    @MESSAGESIGNATURE = AL.MESSAGESIGNATURE,
    @ACTIONTYPECODE = AI.TYPECODE
    from dbo.ADVOCACYACTIVITY (NOLOCK) AA
    inner join dbo.ACTION_ITEM (NOLOCK) AI ON AA.ACTIONITEMID = AI.ID
    inner join dbo.ADVOCACYLOG (nolock) AL on AL.ACTIONITEMID = AI.ID AND AL.SITECONTENTID = AA.SITECONTENTID
    where AA.ID = @ID and AL.CONSTITUENTID = @CONSTITUENTID 
    and AL.ActionItemID = @ActionItemID

    return 0;