USP_DATAFORMTEMPLATE_VIEW_WORKFLOW_ALERT

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@BBWORKFLOWINSTANCEINFOID	uniqueidentifier	INOUT
@WORKFLOWINBOXID	uniqueidentifier	INOUT
@SUBJECT	nvarchar(255)	INOUT
@DESCRIPTION	nvarchar(max)	INOUT
@DATEISSUED	datetime	INOUT
@CATEGORY	nvarchar(50)	INOUT
@ALERTPAGEID	uniqueidentifier	INOUT
@BBWORKFLOWBUSINESSACTIVITYID	uniqueidentifier	INOUT
@LOOKUPID	nvarchar(100)	INOUT
@WORKFLOWINSTANCE_LOOKUPID	nvarchar(100)	INOUT
@WORKFLOWINBOXNAME	nvarchar(200)	INOUT
@WORKFLOWCATALOGID	uniqueidentifier	INOUT
@WORKFLOWCATALOGNAME	nvarchar(100)	INOUT
@HASALERTPAGE	bit	INOUT

Definition

Copy


create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_WORKFLOW_ALERT

    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @BBWORKFLOWINSTANCEINFOID uniqueidentifier = null output,
    @WORKFLOWINBOXID uniqueidentifier = null output,
    @SUBJECT nvarchar(255) = null output,
    @DESCRIPTION nvarchar(max) = null output,
    @DATEISSUED datetime = null output,
    @CATEGORY nvarchar(50) = null output,
    @ALERTPAGEID uniqueidentifier = null output,
    @BBWORKFLOWBUSINESSACTIVITYID uniqueidentifier = null output,
    @LOOKUPID nvarchar(100) = null output,
    @WORKFLOWINSTANCE_LOOKUPID nvarchar(100) = null output,
    @WORKFLOWINBOXNAME nvarchar(200) = null output,
    @WORKFLOWCATALOGID uniqueidentifier=null output,
    @WORKFLOWCATALOGNAME nvarchar(100) = null output,
    @HASALERTPAGE bit = null output

as
    set nocount on;

    set @DATALOADED = 0;

    select @DATALOADED = 1,
           @BBWORKFLOWINSTANCEINFOID = A.BBWORKFLOWINSTANCEINFOID, 
           @WORKFLOWINBOXID = A.BBWORKFLOWINBOXID, 
           @SUBJECT = A.SUBJECT, 
           @DESCRIPTION = A.DESCRIPTION,
           @DATEISSUED = A.DATEISSUED, 
           @CATEGORY = A.CATEGORY,
           @ALERTPAGEID = A.ALERTPAGEID,
           @BBWORKFLOWBUSINESSACTIVITYID = A.BBWORKFLOWBUSINESSACTIVITYID,
           @LOOKUPID = A.LOOKUPID                                                    
    from dbo.BBWORKFLOWALERT as A
    where ID = @ID;

    if @DATALOADED = 1
        begin
            select @WORKFLOWINSTANCE_LOOKUPID = LOOKUPID, @WORKFLOWCATALOGID = BBWORKFLOWCATALOGID from dbo.BBWORKFLOWINSTANCEINFO where ID = @BBWORKFLOWINSTANCEINFOID;
            select @WORKFLOWINBOXNAME = NAME from dbo.BBWORKFLOWINBOX where ID = @WORKFLOWINBOXID;
            select @WORKFLOWCATALOGNAME = NAME from dbo.BBWORKFLOWCATALOG where ID = @WORKFLOWCATALOGID;
        end

    if @ALERTPAGEID is null
        set @HASALERTPAGE = 0;
    else
        set @HASALERTPAGE = 1;

    return 0;