USP_SIMPLEDATALIST_BATCHWORKFLOWTASKS

Returns all batch tasks for a given workflow state.

Parameters

Parameter Parameter Type Mode Description
@BATCHWORKFLOWSTATEID uniqueidentifier IN

Definition

Copy


CREATE procedure dbo.USP_SIMPLEDATALIST_BATCHWORKFLOWTASKS(@BATCHWORKFLOWSTATEID uniqueidentifier)
as
    set NOCOUNT on;
    select BATCHWORKFLOWTASK.ID value, BATCHWORKFLOWTASK.NAME label from dbo.BATCHWORKFLOWTASK where BATCHWORKFLOWSTATEID = @BATCHWORKFLOWSTATEID;