UFN_BUSINESSPROCESS_CURRENTLYRUNBY_WITHPARAMETERSET

Return

Return Type
nvarchar(255)

Parameters

Parameter	Parameter Type	Mode
@BUSINESSPROCESSCATALOGID	uniqueidentifier	IN
@BUSINESSPROCESSPARAMETERSETID	uniqueidentifier	IN
@BUSINESSPROCESSSTATUSID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_BUSINESSPROCESS_CURRENTLYRUNBY_WITHPARAMETERSET
   (
      @BUSINESSPROCESSCATALOGID  uniqueidentifier,  
    @BUSINESSPROCESSPARAMETERSETID uniqueidentifier,
    @BUSINESSPROCESSSTATUSID uniqueidentifier
   )  
   returns nvarchar(255) 
   with execute as caller  
   as  
   begin  
    declare @USERNAME nvarchar(255)
      set @USERNAME = ''

    if exists( 
    select 1 from
     dbo.BUSINESSPROCESSSTATUS 
    where  
     BUSINESSPROCESSPARAMETERSETID  = @BUSINESSPROCESSPARAMETERSETID
     and BUSINESSPROCESSCATALOGID = @BUSINESSPROCESSCATALOGID
     and BUSINESSPROCESSSTATUS.ID <> @BUSINESSPROCESSSTATUSID 
     and STATUSCODE =1)
     begin

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

     end

    return @USERNAME;
   end