USP_SIMPLEDATALIST_FUNDINGREQUESTOUTLINE

Returns a list of all funding request outlines.

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_SIMPLEDATALIST_FUNDINGREQUESTOUTLINE
                (
                    @CURRENTAPPUSERID uniqueidentifier = null,
                    @SECURITYFEATUREID uniqueidentifier = null,
                    @SECURITYFEATURETYPE tinyint = null
                )
                as begin
                    set nocount on;
                    select 
                        FUNDINGREQUESTOUTLINE.ID as VALUE,
                        case 
                          when SITE.NAME is null then FUNDINGREQUESTOUTLINE.NAME
                          else FUNDINGREQUESTOUTLINE.NAME + ' (' + SITE.NAME    + ')'
                        end as LABEL
                    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)))
                    order by
                        FUNDINGREQUESTOUTLINE.NAME
                end