UFN_BUSINESSPROCESSINSTANCE_GETOWNER
Returns the owner of the given business process instance.
Return
Return Type |
---|
uniqueidentifier |
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@BUSINESSPROCESSCATALOGID | uniqueidentifier | IN | |
@BUSINESSPROCESSPARAMETERSETID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_BUSINESSPROCESSINSTANCE_GETOWNER(@BUSINESSPROCESSCATALOGID uniqueidentifier, @BUSINESSPROCESSPARAMETERSETID uniqueidentifier)
returns uniqueidentifier
with execute as caller
as begin
declare @OWNERID uniqueidentifier
select @OWNERID = OWNERID
from dbo.BUSINESSPROCESSINSTANCE
where BUSINESSPROCESSCATALOGID = @BUSINESSPROCESSCATALOGID and BUSINESSPROCESSPARAMETERSETID = @BUSINESSPROCESSPARAMETERSETID
return @OWNERID
end