UFN_BATCHWORKFLOWTASK

Returns tasks linked to a specific workflow

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHWORKFLOWID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_BATCHWORKFLOWTASK(@BATCHWORKFLOWID uniqueidentifier)
returns table

as return
select
    ID,
        BATCHWORKFLOWSTATEID,
        NEXTBATCHWORKFLOWSTATEID,
    BATCHWORKFLOWID,
        NAME
  from 
        dbo.BATCHWORKFLOWTASK   
    where BATCHWORKFLOWID = @BATCHWORKFLOWID