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