UFN_APPUSER_HASBUSINESSPROCESSHISTORY

Returns true if the user is linked to business process history records.

Return

Return Type
bit

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy


CREATE function dbo.UFN_APPUSER_HASBUSINESSPROCESSHISTORY (@ID uniqueidentifier)
returns bit
as
begin
    if exists(select ID from dbo.BUSINESSPROCESSSTATUS where STARTEDBYUSERID = @ID)
        return 1;

    return 0;
end