UFN_BBWORKFLOW_WORKFLOWTASKDATAITEM_GETVALUE
Return
| Return Type |
|---|
| nvarchar(max) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BBWORKFLOWTASKID | uniqueidentifier | IN | |
| @ITEMKEY | nvarchar(255) | IN |
Definition
Copy
create function dbo.UFN_BBWORKFLOW_WORKFLOWTASKDATAITEM_GETVALUE
(
@BBWORKFLOWTASKID uniqueidentifier,
@ITEMKEY nvarchar(255)
)
returns nvarchar(max)
as
begin
declare @data nvarchar(max);
select @data = DATAITEM
from dbo.BBWORKFLOWTASKDATAITEM
where (BBWORKFLOWTASKID = @BBWORKFLOWTASKID) and (ITEMKEY = @ITEMKEY);
return @data;
end