UFN_APPUSER_HASWORKFLOWHISTORY

Return

Return Type
bit

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy


create function dbo.UFN_APPUSER_HASWORKFLOWHISTORY(@ID uniqueidentifier)
returns bit
as begin
    if exists(select null from dbo.BBWORKFLOWINSTANCEINFO where INITIATEDBY_APPUSERID = @ID)
        return 1;
    if exists(select null from dbo.BBWORKFLOWTASK where COMPLETEDBY_APPUSERID = @ID)
        return 1;

    return 0;
end