UFN_PAPERLESSMANDATES_ENABLED_FORUSERONFEATURE

Returns a flag indicating if paperless mandates are enabled for a given user on a feature.

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode
@APPUSERID	uniqueidentifier	IN
@FEATUREID	uniqueidentifier	IN
@FEATURETYPE	tinyint	IN

Definition

Copy



            CREATE function dbo.UFN_PAPERLESSMANDATES_ENABLED_FORUSERONFEATURE
            (
                @APPUSERID uniqueidentifier,
                @FEATUREID uniqueidentifier,
                @FEATURETYPE tinyint
            )
            returns integer
            with execute as caller
            as begin

                declare @ENABLED integer;
                set @ENABLED = 0;
                declare @SITECOUNT integer;
                set @SITECOUNT = 0;

                select 
                    @SITECOUNT = count(*)
                from 
                    dbo.UFN_SITESFORUSERONFEATURE(@APPUSERID,@FEATUREID,@FEATURETYPE)
                where 
                (
                    (select dbo.UFN_PAPERLESSMANDATES_ENABLED_FORSITE(SITEID)) = 1
                )

                if @SITECOUNT > 0
                    set @ENABLED = 1;

                if @ENABLED = 0
                    begin
                        select @SITECOUNT = COUNT(*) from dbo.SITE;

                        if @SITECOUNT = 0
                            select @ENABLED = 1 from dbo.PAPERLESSMANDATESCONFIGURATION;
                    end

                return @ENABLED;
            end