USP_DATALIST_BATCH2WORKFLOWSTATE

Returns all Batch Workflow Status records 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_BATCH2WORKFLOWSTATE(@BATCHWORKFLOWID uniqueidentifier)
as                
    select 
        [BATCHWORKFLOWSTATE].[ID], 
        [BATCHWORKFLOWSTATE].[NAME], 
        [BATCHWORKFLOWSTATE].[ISINITIALSTATE],
    [BATCHWORKFLOWSTATE].[ALLOWEDIT], 
    [BATCHWORKFLOWSTATE].[ALLOWCOMMIT], 
    [BATCHWORKFLOWSTATE].[ENFORCETOTALMATCHING], 
        [BATCHWORKFLOWSTATE].[OVERDUEIN]
    from dbo.[BATCHWORKFLOWSTATE]
    where [BATCHWORKFLOWSTATE].[BATCHWORKFLOWID] = @BATCHWORKFLOWID
    order by [BATCHWORKFLOWSTATE].[NAME];