USP_DATALIST_PLEDGEWRITEOFFPROCESS

This datalist returns a list of saved pledge write-off 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_PLEDGEWRITEOFFPROCESS
                (
                    @CURRENTAPPUSERID uniqueidentifier = null,
                    @SITEFILTERMODE tinyint = 0,
                    @SITESSELECTED xml = null,
                    @SECURITYFEATUREID uniqueidentifier = null,
                    @SECURITYFEATURETYPE tinyint = null
                )
                as begin
                    set NOCOUNT on;
                    select 
                        PLEDGEWRITEOFFPROCESS.ID, 
                        PLEDGEWRITEOFFPROCESS.NAME, 
                        PLEDGEWRITEOFFPROCESS.DESCRIPTION,
                        IDSETREGISTER.NAME,
                        PLEDGEWRITEOFFPROCESS.POSTSTATUS,
                        PLEDGEWRITEOFFPROCESS.POSTDATE,
                        BPI.OWNERID as OWNERID,
                        coalesce(SITE.NAME,'All Sites') SITES
                    from 
                        dbo.PLEDGEWRITEOFFPROCESS
                    inner join
                        dbo.IDSETREGISTER on PLEDGEWRITEOFFPROCESS.IDSETREGISTERID = IDSETREGISTER.ID
                    left join dbo.BUSINESSPROCESSINSTANCE BPI on PLEDGEWRITEOFFPROCESS.ID = BPI.BUSINESSPROCESSPARAMETERSETID
                    left join dbo.SITE on SITE.ID = BPI.SITEID
                    where (dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE(@CURRENTAPPUSERID, PLEDGEWRITEOFFPROCESS.ID) = 1)
                            and (
                                        (
                                             (--Check site security

                                                         select count(1) 
                                                         from dbo.UFN_BUSINESSPROCESSPARAMETERSET_GETSITES(PLEDGEWRITEOFFPROCESS.ID) as PLEDGEWRITEOFFPROCESSSITE 
                                                         where (dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 or exists (select 1 from dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID,@SECURITYFEATUREID,@SECURITYFEATURETYPE) where SITEID=[PLEDGEWRITEOFFPROCESSSITE].[SITEID] or (SITEID is null and [PLEDGEWRITEOFFPROCESSSITE].[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
                        PLEDGEWRITEOFFPROCESS.NAME;
                end