USP_DATALIST_BATCHWORKFLOWTASKS

Returns a list of all batch workflow tasks for a given batch workflow. Replaced by Batch Workflow Steps Data List.

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_DATALIST_BATCHWORKFLOWTASKS(@BATCHWORKFLOWSTATEID uniqueidentifier)
as                
    select [BATCHWORKFLOWTASK].[ID], [BATCHWORKFLOWTASK].[NAME],
        (select [BATCHWORKFLOWSTATE].[NAME] from dbo.[BATCHWORKFLOWSTATE] where [BATCHWORKFLOWSTATE].[ID] = BATCHWORKFLOWTASK.NEXTBATCHWORKFLOWSTATEID) as NEXTSTATENAME
        from dbo.[BATCHWORKFLOWTASK] 
        where [BATCHWORKFLOWTASK].[BATCHWORKFLOWSTATEID] = @BATCHWORKFLOWSTATEID
        order by [BATCHWORKFLOWTASK].[NAME];