UFN_BBWORKFLOW_WORKFLOWDATAITEM_GETVALUE
Returns the data item payload that was associated with the workflow instance by the given key
Return
| Return Type |
|---|
| nvarchar(max) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BBWORKFLOWINSTANCEINFOID | uniqueidentifier | IN | |
| @ITEMKEY | nvarchar(255) | IN |
Definition
Copy
CREATE FUNCTION dbo.UFN_BBWORKFLOW_WORKFLOWDATAITEM_GETVALUE(@BBWORKFLOWINSTANCEINFOID uniqueidentifier,@ITEMKEY nvarchar(255))
returns nvarchar(max)
as
begin
declare @data nvarchar(max);
select @data=DATAITEM from dbo.BBWORKFLOWDATAITEM WHERE BBWORKFLOWINSTANCEINFOID=@BBWORKFLOWINSTANCEINFOID AND ITEMKEY=@ITEMKEY;
return @data;
end