USP_DATALIST_BATCHWORKFLOWSTATES

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

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_BATCHWORKFLOWSTATES(@BATCHWORKFLOWID uniqueidentifier)
as                
    select 
        [BATCHWORKFLOWSTATE].[ID], 
        [BATCHWORKFLOWSTATE].[NAME], 
        [BATCHWORKFLOWSTATE].[ALLOWCOMMIT], 
        [BATCHWORKFLOWSTATE].[ENFORCETOTALMATCHING], 
        [BATCHWORKFLOWSTATE].[ALLOWEDIT], 
        [BATCHWORKFLOWSTATE].[ISINITIALSTATE],
        [BATCHWORKFLOWSTATE].[OVERDUEIN],
        dbo.UFN_BATCHWORKFLOWSTATE_GETTASKS(BATCHWORKFLOWSTATE.ID) TASKLIST
    from dbo.[BATCHWORKFLOWSTATE]
    where [BATCHWORKFLOWSTATE].[BATCHWORKFLOWID] = @BATCHWORKFLOWID
    order by [BATCHWORKFLOWSTATE].[NAME];