USP_DATALIST_DONORCHALLENGEENCUMBERPROCESS

Returns a list of Update Donor Challenge Business process parameter sets.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@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_DONORCHALLENGEENCUMBERPROCESS(
                    @CURRENTAPPUSERID uniqueidentifier = null,
                    @SITEFILTERMODE tinyint = 0,
                    @SITESSELECTED xml = null,
                    @SECURITYFEATUREID uniqueidentifier = null,
                    @SECURITYFEATURETYPE tinyint = null
                )
                as 
                begin
                    set nocount on

                    select 
                        DONORCHALLENGEENCUMBERPROCESS.ID, 
                        DONORCHALLENGEENCUMBERPROCESS.NAME as PROCESSNAME,
                        BPI.OWNERID as OWNERID,
                        BPI.BUSINESSPROCESSCATALOGID,
                        BPI.BUSINESSPROCESSPARAMETERSETID,
                        coalesce(SITE.NAME,'All Sites') SITE
                    from dbo.DONORCHALLENGEENCUMBERPROCESS
                        left join dbo.BUSINESSPROCESSINSTANCE BPI on DONORCHALLENGEENCUMBERPROCESS.ID = BPI.BUSINESSPROCESSPARAMETERSETID
                        left join dbo.SITE on SITE.ID = BPI.SITEID
                    where 
                        (dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE(@CURRENTAPPUSERID, DONORCHALLENGEENCUMBERPROCESS.ID) = 1)
                        and
                        (
                            (
                                (--Check site security

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

                end