USP_DATALIST_RECOGNITIONPROGRAM

Provides a list of recognition programs.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@INCLUDEINACTIVE	bit	IN	Include inactive programs
@SITEFILTERMODE	tinyint	IN	Sites
@SITESSELECTED	xml	IN
@SECURITYFEATUREID	uniqueidentifier	IN	Input parameter indicating the ID of the feature to use for site security checking.
@SECURITYFEATURETYPE	tinyint	IN	Input parameter indicating the type of the feature to use for site security checking.

Definition

Copy



            CREATE procedure dbo.USP_DATALIST_RECOGNITIONPROGRAM
                (
                    @CURRENTAPPUSERID uniqueidentifier = null,
                    @INCLUDEINACTIVE bit = 0,
                        @SITEFILTERMODE tinyint = 0,
                    @SITESSELECTED xml = null,
                    @SECURITYFEATUREID uniqueidentifier = null,
                    @SECURITYFEATURETYPE tinyint = null
                )
            as
                set nocount on;

                select RECOGNITIONPROGRAM.ID,
                       RECOGNITIONPROGRAM.NAME,
                       RECOGNITIONPROGRAM.DESCRIPTION,
                       RECOGNITIONPROGRAM.TYPE,
                       SITE.NAME,
                       case when RECOGNITIONPROGRAM.TYPECODE = 0 then RECOGNITIONPROGRAM.EXPIRESON
                            else '' end as EXPIRESON,
                       RECOGNITIONPROGRAM.ISACTIVE
                from dbo.RECOGNITIONPROGRAM
                left join dbo.SITE on RECOGNITIONPROGRAM.SITEID = SITE.ID
                where
                    (dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 or exists (select 1 from dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID,@SECURITYFEATUREID,@SECURITYFEATURETYPE) where SITEID=[RECOGNITIONPROGRAM].[SITEID] or (SITEID is null and [RECOGNITIONPROGRAM].[SITEID] is null)))
                    and (@SITEFILTERMODE = 0
                        or RECOGNITIONPROGRAM.SITEID in ( 
                            select SITEID
                            from dbo.UFN_SITE_BUILDDATALISTSITEFILTER (@CURRENTAPPUSERID, @SITEFILTERMODE, @SITESSELECTED)
                        )
                        or @CURRENTAPPUSERID is null
                    )
                    and (RECOGNITIONPROGRAM.ISACTIVE = 1 or @INCLUDEINACTIVE = 1)
                order by RECOGNITIONPROGRAM.NAME asc;