USP_DATAFORMTEMPLATE_VIEW_ACTIONITEMDETAILPROFILE
The load procedure used by the view dataform template "Action Item 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 |
| @CLASSIFICATION | nvarchar(30) | INOUT | Classification |
| @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_ACTIONITEMDETAILPROFILE
(
@ID uniqueidentifier,
@DATALOADED bit = 0 output,
@ACTIONITEMNAME nvarchar(500) = null output,
@ACTIONCENTERNAME nvarchar(512) = null output,
@CLASSIFICATION nvarchar(30) = 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,
@CLASSIFICATION = AI.TOPIC,
@DATE = Convert(varchar, AA.DATEADDED, 101),
@ACTIONITEMTYPE = AI.TYPE,
@FEDERALDISTRICTCODE = AL.FEDERALDISTRICTCODE,
@UPPERSTATEDISTRICTCODE = AL.UPPERSTATEDISTRICTCODE,
@LOWERSTATEDISTRICTCODE = AL.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.ADVOCACYLOG (nolock) AL on AL.ACTIONITEMID = AA.ACTIONITEMID and AL.CONSTITUENTID = AA.CONSTITUENTID
where AA.ID=@ID
return 0;