USP_DATAFORMTEMPLATE_VIEW_BBWORKFLOWINSTANCEINFO_SUMMARY

The load procedure used by the view dataform template "Workflow Instance Page Summary 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.
@WORKFLOWCATALOGNAME	nvarchar(60)	INOUT	Workflow type
@WORKFLOWCATALOGDESCRIPTION	nvarchar(100)	INOUT	Workflow description
@WORKFLOWSTARTDATE	datetimeoffset	INOUT	Start date
@STARTEDBYUSERNAME	nvarchar(255)	INOUT	Started by
@STARTSTATUS	nvarchar(25)	INOUT	Start status
@STARTSTATUSCODE	tinyint	INOUT	Start status code
@LOOKUPID	nvarchar(100)	INOUT	Lookup ID
@COMPLETIONSTATE	nvarchar(25)	INOUT	Completion state
@WORKFLOWENDDATE	datetimeoffset	INOUT	Completed date
@ISRUNNING	bit	INOUT	Running?
@COMPLETIONSTATECODE	tinyint	INOUT
@HASASSIGNEDTASK	bit	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_BBWORKFLOWINSTANCEINFO_SUMMARY

    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @WORKFLOWCATALOGNAME nvarchar(60) = null output,
    @WORKFLOWCATALOGDESCRIPTION nvarchar(100) = null output,
    @WORKFLOWSTARTDATE datetimeoffset = null output,
    @STARTEDBYUSERNAME nvarchar(255) = null output,
    @STARTSTATUS nvarchar(25) = null output,
    @STARTSTATUSCODE tinyint = null output,
    @LOOKUPID nvarchar(100)=null output,
    @COMPLETIONSTATE nvarchar(25) = null output,
    @WORKFLOWENDDATE datetimeoffset = null output,
    @ISRUNNING bit = null output,
    @COMPLETIONSTATECODE tinyint = null output,
    @HASASSIGNEDTASK bit = null output

as
    set nocount on;
    set @DATALOADED = 0;

    select 
        @DATALOADED = 1,        
        @WORKFLOWCATALOGNAME = WC.NAME ,
        @WORKFLOWSTARTDATE= WI.WORKFLOWSTARTDATE ,
        @STARTEDBYUSERNAME = STARTEDBYUSER.DISPLAYNAME ,
        @STARTSTATUS= WI.STARTSTATUS,
        @STARTSTATUSCODE = WI.STARTSTATUSCODE,
        @LOOKUPID=WI.LOOKUPID,
        @COMPLETIONSTATE=WI.COMPLETIONSTATE,
        @WORKFLOWENDDATE=WI.WORKFLOWENDDATE,
        @ISRUNNING=WI.ISRUNNING,
        @COMPLETIONSTATECODE=WI.COMPLETIONSTATECODE
    from 
        dbo.BBWORKFLOWINSTANCEINFO AS WI
        inner join dbo.BBWORKFLOWCATALOG AS WC ON WI.BBWORKFLOWCATALOGID=WC.ID
        inner join dbo.APPUSER AS STARTEDBYUSER on WI.INITIATEDBY_APPUSERID =STARTEDBYUSER.ID
    where WI.ID = @ID;

    set @HASASSIGNEDTASK = 0;
    select top 1 @HASASSIGNEDTASK = 1 
        from dbo.BBWORKFLOWTASK 
        where BBWORKFLOWINSTANCEINFOID = @ID 
            and TASKSTATUSCODE=0
        order by DATEADDED desc;

    return 0;