USP_DATALIST_PRENOTIFICATIONPROCESS

This datalist returns a list of saved prenotification process parameter sets.
Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SITEFILTERMODE	tinyint	IN
@SITESSELECTED	xml	IN
@SECURITYFEATUREID	uniqueidentifier	IN
@SECURITYFEATURETYPE	tinyint	IN
Definition

Copy


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

                select
                    PRENOTIFICATIONPROCESS.ID,
                    PRENOTIFICATIONPROCESS.NAME,
                    PRENOTIFICATIONPROCESS.DESCRIPTION,
                    IDSETREGISTER.NAME,
                    case PRENOTIFICATIONPROCESS.DATETYPECODE
                        when 0 then getdate()
                        else PRENOTIFICATIONPROCESS.DATE
                    end,
                    BPI.OWNERID as OWNERID,
                    coalesce(SITE.NAME,'All Sites') SITES
                from
                    dbo.PRENOTIFICATIONPROCESS
                left join dbo.IDSETREGISTER on PRENOTIFICATIONPROCESS.IDSETREGISTERID = IDSETREGISTER.ID
                left join dbo.BUSINESSPROCESSINSTANCE BPI on PRENOTIFICATIONPROCESS.ID = BPI.BUSINESSPROCESSPARAMETERSETID
                left join dbo.SITE on SITE.ID = BPI.SITEID
                where (dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE(@CURRENTAPPUSERID, PRENOTIFICATIONPROCESS.ID) = 1)
                and (
                        (
                            (--Check site security

                                select count(1) 
                                from dbo.UFN_BUSINESSPROCESSPARAMETERSET_GETSITES(PRENOTIFICATIONPROCESS.ID) as PRENOTIFICATIONPROCESSSITE 
                                where (dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 or exists (select 1 from dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID,@SECURITYFEATUREID,@SECURITYFEATURETYPE) where SITEID=[PRENOTIFICATIONPROCESSSITE].[SITEID] or (SITEID is null and [PRENOTIFICATIONPROCESSSITE].[SITEID] is null)))
                            ) > 0
                        )
                        and (--Apply site filter

                            @SITEFILTERMODE = 0
                                or BPI.SITEID in (
                                    select SITEID
                                    from dbo.UFN_SITE_BUILDDATALISTSITEFILTER (@CURRENTAPPUSERID, @SITEFILTERMODE, @SITESSELECTED) 
                                )
                        )
                    )
                order by
                    PRENOTIFICATIONPROCESS.NAME;