UFN_BUSINESSPROCESS_CURRENTLYRUNBY

Return

Return Type
nvarchar(255)

Parameters

Parameter	Parameter Type	Mode	Description
@BUSINESSPROCESSCATALOGID	uniqueidentifier	IN
@IGNOREID	nvarchar(50)	IN

Definition

Copy


            create function dbo.UFN_BUSINESSPROCESS_CURRENTLYRUNBY(@BUSINESSPROCESSCATALOGID uniqueidentifier, @IGNOREID nvarchar(50))
            returns nvarchar(255)
            with execute as caller
            as
            begin
                declare @USERNAME nvarchar(255)
                set @USERNAME = ''

                select 
                    @USERNAME = STARTEDBY.USERNAME 
                from 
                    dbo.BUSINESSPROCESSSTATUS 
                    inner join dbo.APPUSER as STARTEDBY on STARTEDBY.ID = BUSINESSPROCESSSTATUS.STARTEDBYUSERID 
                where 
                    BUSINESSPROCESSSTATUS.BUSINESSPROCESSCATALOGID = @BUSINESSPROCESSCATALOGID and 
                    BUSINESSPROCESSSTATUS.STATUSCODE = 1 and 
                    BUSINESSPROCESSSTATUS.ID <> @IGNOREID

                return @USERNAME
            end