USP_SIMPLEDATALIST_RESEARCHGROUPS

Returns a list of all research groups.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@FILTERFORSECURITY	bit	IN

Definition

Copy



                CREATE procedure dbo.USP_SIMPLEDATALIST_RESEARCHGROUPS (
                    @CURRENTAPPUSERID uniqueidentifier,
          @FILTERFORSECURITY bit = 0
                ) as
                    set nocount on;

                    select
                        RG.ID as VALUE,
                        RG.NAME as LABEL
                    from
                        dbo.RESEARCHGROUP RG
          where
                        (@FILTERFORSECURITY = 0 or
             RG.OTHERSCANMODIFY = 1 or
                         RG.OWNERID = @CURRENTAPPUSERID or
                         RG.OWNERID is null or
                         dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1) 
                    order by
                        RG.NAME;