USP_SIMPLEDATALIST_RESEARCHGROUPSFORAPPUSER

Returns a list of all research groups that an app user has rights to modify.

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_SIMPLEDATALIST_RESEARCHGROUPSFORAPPUSER (
                    @CURRENTAPPUSERID uniqueidentifier,
                    @SITESECURITYFEATUREID uniqueidentifier = null,
                    @SITESECURITYFEATURETYPE tinyint = null
                ) as
                    set nocount on;

                    select
                        RG.ID as VALUE,
                        RG.NAME as LABEL
                    from
                        dbo.RESEARCHGROUP RG
                    left join
                        dbo.APPUSER AU on AU.ID = RG.OWNERID
                    where
                        (RG.OTHERSCANMODIFY = 1 or
                         RG.OWNERID = @CURRENTAPPUSERID or
                         RG.OWNERID is null or
                         dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1) and 
                         dbo.UFN_RESEARCHGROUP_USERHASSITEACCESS(RG.ID, @CURRENTAPPUSERID, @SITESECURITYFEATUREID, @SITESECURITYFEATURETYPE) = 1
                    order by
                        RG.NAME;