UFN_BBNC_NUMBEROFDEFAULTRULES

Returns the number of default rules for a Blackbaud Internet Solutions transaction processor.

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@NETCOMMUNITYTRANSACTIONPROCESSORID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_BBNC_NUMBEROFDEFAULTRULES
            (
                @NETCOMMUNITYTRANSACTIONPROCESSORID uniqueidentifier
            )
            returns int
            as
            begin
                declare @R int;

                select @R = count(ID) 
                from dbo.NETCOMMUNITYMAPPINGRULE
                where NETCOMMUNITYTRANSACTIONPROCESSORID = @NETCOMMUNITYTRANSACTIONPROCESSORID
                    and MAPPINGTYPECODE = 0;

                select @R = coalesce(@R, 0);

                return @R;
            end