UFN_BUSINESSPROCESS_IDSETCANBECREATED

Validates whether the id set can be created by a business process. ID sets created by query cannot be overwritten.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@IDSETNAME	nvarchar(100)	IN

Definition

Copy



CREATE function dbo.UFN_BUSINESSPROCESS_IDSETCANBECREATED(@IDSETNAME nvarchar(100)) returns bit with execute as caller
as
begin

    declare @COUNT int

    select 
        @COUNT = count(IDSETREGISTER.ID) 
    from
        dbo.IDSETREGISTER                    
    where
        IDSETREGISTER.NAME = @IDSETNAME and
        (
        exists(select IDSETREGISTERID FROM dbo.IDSETREGISTERADHOCQUERY where IDSETREGISTERADHOCQUERY.IDSETREGISTERID = IDSETREGISTER.ID) 
        or
        exists(select IDSETREGISTERID FROM dbo.IDSETREGISTERSMARTQUERYINSTANCE where IDSETREGISTERSMARTQUERYINSTANCE.IDSETREGISTERID = IDSETREGISTER.ID)
        )

    if @COUNT > 0
        return 0

    return 1
end