USP_DATAFORMTEMPLATE_VIEW_WORKFLOW_TASK

The load procedure used by the view dataform template "Workflow Task 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.
@BBWORKFLOWINSTANCEINFOID	uniqueidentifier	INOUT	BBWORKFLOWINSTANCEINFOID
@WORKFLOWINBOXID	uniqueidentifier	INOUT	Workflow inbox
@TASKSUBJECT	nvarchar(255)	INOUT	Task subject
@TASKDESCRIPTION	nvarchar(max)	INOUT	Task description
@COMPLETED	bit	INOUT	Completed
@DATEASSIGNED	datetime	INOUT	Date assigned
@DATEDUE	datetime	INOUT	Date due
@DATECOMPLETED	datetime	INOUT	Date completed
@CATEGORY	nvarchar(50)	INOUT	Category
@TASKSTATUSCODE	tinyint	INOUT	Task status code
@TASKSTATUS	nvarchar(25)	INOUT	Task status
@CANCELLED	bit	INOUT	Cancelled
@HIDDEN	bit	INOUT	Hidden
@USERCANCANCEL	bit	INOUT	User can cancel
@USERCANCOMPLETE	bit	INOUT	User can complete
@TASKPAGEID	uniqueidentifier	INOUT	Task page ID
@BBWORKFLOWBUSINESSACTIVITYID	uniqueidentifier	INOUT	Business activity id
@LOOKUPID	nvarchar(100)	INOUT	Lookup ID
@WORKFLOWINSTANCE_LOOKUPID	nvarchar(100)	INOUT	Workflow instance
@WORKFLOWINBOXNAME	nvarchar(200)	INOUT	Assigned to inbox
@WORKFLOWCATALOGID	uniqueidentifier	INOUT	Workflow catalog ID
@WORKFLOWCATALOGNAME	nvarchar(100)	INOUT	Workflow type
@COMPLETEDBY_APPUSERID	uniqueidentifier	INOUT	Completed by user ID
@COMPLETEDBY_APPUSERNAME	nvarchar(200)	INOUT	Completed by
@HASTASKPAGE	bit	INOUT
@OWNER_APPUSERID	uniqueidentifier	INOUT
@OWNER_APPUSERNAME	nvarchar(255)	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_WORKFLOW_TASK 

    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @BBWORKFLOWINSTANCEINFOID uniqueidentifier = null output,
    @WORKFLOWINBOXID uniqueidentifier = null output,
    @TASKSUBJECT nvarchar(255) = null output,
    @TASKDESCRIPTION nvarchar(max) = null output,
    @COMPLETED bit = null output,
    @DATEASSIGNED datetime = null output,
    @DATEDUE datetime = null output,
    @DATECOMPLETED datetime = null output,
    @CATEGORY nvarchar(50) = null output,
    @TASKSTATUSCODE tinyint=null output,
    @TASKSTATUS nvarchar(25) = null output,
    @CANCELLED bit = null output,
    @HIDDEN bit = null output,
    @USERCANCANCEL bit = null output,
    @USERCANCOMPLETE bit = null output,
    @TASKPAGEID 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,
    @COMPLETEDBY_APPUSERID uniqueidentifier = null output,
    @COMPLETEDBY_APPUSERNAME nvarchar(200) = null output,
  @HASTASKPAGE bit = null output,
  @OWNER_APPUSERID uniqueidentifier = null output,
  @OWNER_APPUSERNAME nvarchar(255) = null output


as

    set nocount on;

    set @DATALOADED = 0;

    select @DATALOADED = 1,
           @BBWORKFLOWINSTANCEINFOID = T.BBWORKFLOWINSTANCEINFOID, 
           @WORKFLOWINBOXID = T.BBWORKFLOWINBOXID, 
           @TASKSUBJECT = T.TASKSUBJECT, 
           @TASKDESCRIPTION = T.TASKDESCRIPTION, 
           @COMPLETED = CASE WHEN T.TASKSTATUSCODE=0 THEN 0 ELSE 1 END, 
           @DATEASSIGNED = T.DATEASSIGNED, 
           @DATEDUE = T.DATEDUE, 
           @DATECOMPLETED = T.DATECOMPLETED, 
           @CATEGORY = T.CATEGORY,
           @TASKSTATUSCODE=T.TASKSTATUSCODE,
           @TASKSTATUS=T.TASKSTATUS,
           @CANCELLED=CASE WHEN T.TASKSTATUSCODE=2 THEN 1 ELSE 0 END,
           @HIDDEN=T.HIDDEN,
           @USERCANCANCEL=T.USERCANCANCEL,
           @USERCANCOMPLETE=T.USERCANCOMPLETE,
           @TASKPAGEID=T.TASKPAGEID,
           @BBWORKFLOWBUSINESSACTIVITYID=T.BBWORKFLOWBUSINESSACTIVITYID,
           @LOOKUPID =  T.LOOKUPID,
           @COMPLETEDBY_APPUSERID=T.COMPLETEDBY_APPUSERID,
           @OWNER_APPUSERID=T.OWNER_APPUSERID


    from dbo.BBWORKFLOWTASK as T
    where ID = @ID;

    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;

    if @COMPLETEDBY_APPUSERID is not null
        select @COMPLETEDBY_APPUSERNAME=COALESCE(COALESCE( AU.DISPLAYNAME , AU.USERNAME),N'') from dbo.APPUSER AS AU WHERE AU.ID=@COMPLETEDBY_APPUSERID;

  if @TASKPAGEID is null
    set @HASTASKPAGE = 0;
  else
    set @HASTASKPAGE = 1;

    if @OWNER_APPUSERID is not null
        select @OWNER_APPUSERNAME=COALESCE(COALESCE( AU.DISPLAYNAME , AU.USERNAME),N'') from dbo.APPUSER AS AU WHERE AU.ID=@OWNER_APPUSERID;



    return 0;