USP_DATALIST_BATCH2WORKFLOWTASKS

Returns a list of all batch workflow steps for a given batch workflow.

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHWORKFLOWID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_BATCH2WORKFLOWTASKS(@BATCHWORKFLOWID uniqueidentifier)
as
    select [BWT].[ID]
    ,BWS.NAME as FROMSTATENAME
    ,BWT.NAME as taskname
    ,BWSN.NAME as NEXTSTATENAME
    from BATCHWORKFLOWTASK as BWT
    join BATCHWORKFLOWSTATE as BWS on BWT.BATCHWORKFLOWSTATEID = BWS.ID
    join BATCHWORKFLOWSTATE as BWSN on BWT.NEXTBATCHWORKFLOWSTATEID = BWSN.ID
    Where BWS.BATCHWORKFLOWID = @BATCHWORKFLOWID
    order by [BWT].[NAME];