USP_DATALIST_FUNDINGREQUESTOUTLINE

Returns a list of funding request outlines.

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_FUNDINGREQUESTOUTLINE(
                    @CURRENTAPPUSERID uniqueidentifier = null,
                    @SITEFILTERMODE tinyint = 0,
                    @SITESSELECTED xml = null,
                    @SECURITYFEATUREID uniqueidentifier = null,
                    @SECURITYFEATURETYPE tinyint = null
                )
                as
                    set nocount on;

                    select
                        FUNDINGREQUESTOUTLINE.ID,
                        FUNDINGREQUESTOUTLINE.NAME,
                        (
                            select count(distinct FUNDINGREQUESTSTAGECODEID) 
                            from dbo.FUNDINGREQUESTOUTLINESTEP 
                            where FUNDINGREQUESTOUTLINESTEP.FUNDINGREQUESTOUTLINEID=FUNDINGREQUESTOUTLINE.ID
                        ) STAGES,
                        (
                            select count(*) 
                            from dbo.FUNDINGREQUESTOUTLINESTEP 
                            where FUNDINGREQUESTOUTLINESTEP.FUNDINGREQUESTOUTLINEID=FUNDINGREQUESTOUTLINE.ID
                        ) STEPS,
                        SITE.NAME SITENAME
                    from dbo.FUNDINGREQUESTOUTLINE
                        left join dbo.SITE on SITE.ID = FUNDINGREQUESTOUTLINE.SITEID
                    where
                        (dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 or exists (select 1 from dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID,@SECURITYFEATUREID,@SECURITYFEATURETYPE) where SITEID=[FUNDINGREQUESTOUTLINE].[SITEID] or (SITEID is null and [FUNDINGREQUESTOUTLINE].[SITEID] is null)))
                            and (
                                @SITEFILTERMODE = 0
                                    or FUNDINGREQUESTOUTLINE.SITEID in ( 
                                        select SITEID
                                        from dbo.UFN_SITE_BUILDDATALISTSITEFILTER (@CURRENTAPPUSERID, @SITEFILTERMODE, @SITESSELECTED)
                                    )
                            )
                    order by
                        FUNDINGREQUESTOUTLINE.NAME