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