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;