USP_DATAFORMTEMPLATE_PRELOAD_BATCHWORKFLOWTASK
The load procedure used by the edit dataform template "Batch Workflow Task Add Form"
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@BATCHWORKFLOWSTATEID | uniqueidentifier | IN | Input parameter indicating the context ID for the record being added. |
@BATCHWORKFLOWID | uniqueidentifier | INOUT | Batch workflow id |
@BATCHWORKFLOWSTATE | nvarchar(100) | INOUT | Current state |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_BATCHWORKFLOWTASK
(
@BATCHWORKFLOWSTATEID uniqueidentifier,
@BATCHWORKFLOWID uniqueidentifier = null output,
@BATCHWORKFLOWSTATE nvarchar(100) = null output
)
as
set nocount on;
select @BATCHWORKFLOWID=BATCHWORKFLOWID, @BATCHWORKFLOWSTATE=NAME from dbo.BATCHWORKFLOWSTATE where ID = @BATCHWORKFLOWSTATEID;