USP_DATAFORMTEMPLATE_VIEW_RESEARCHGROUPS_PAGEEXPRESSIONS

The load procedure used by the view dataform template "Research Groups Page Expression View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@RE7SECURITYFEATURESGRANTED	bit	INOUT	RE7SECURITYFEATURESGRANTED
@RE7CONFIGUREDFORUSER	bit	INOUT
@USER_GRANTED_MAPENTITY	bit	INOUT
@MAPPINGCREDENTIALSEXIST	bit	INOUT
@NIGHTLYREFRESHENABLED	bit	INOUT

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_RESEARCHGROUPS_PAGEEXPRESSIONS(
                    @CURRENTAPPUSERID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @RE7SECURITYFEATURESGRANTED bit = null output,
                    @RE7CONFIGUREDFORUSER bit = null output,
                    @USER_GRANTED_MAPENTITY bit = null output,
                    @MAPPINGCREDENTIALSEXIST bit = null output,
                    @NIGHTLYREFRESHENABLED bit = null output
                ) as
                    set nocount on;

                    set @DATALOADED = 1;
          set @RE7CONFIGUREDFORUSER = 0;

                    if dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 or
                       (dbo.UFN_SECURITY_APPUSER_GRANTED_RECORDOPERATION_IN_SYSTEMROLE(@CURRENTAPPUSERID ,'c81183fd-78df-4ebf-8855-b3dcc0b0be33')=1 and
                        dbo.UFN_SECURITY_APPUSER_GRANTED_RECORDOPERATION_IN_SYSTEMROLE(@CURRENTAPPUSERID ,'505760bd-3e81-4c4f-8f21-f59edfd5562d')=1 and
                        dbo.UFN_SECURITY_APPUSER_GRANTED_RECORDOPERATION_IN_SYSTEMROLE(@CURRENTAPPUSERID ,'49675912-2d9a-415b-8f03-ccf9c564796d')=1 and
                        dbo.UFN_SECURITY_APPUSER_GRANTED_DATALIST_IN_SYSTEMROLE(@CURRENTAPPUSERID,'ab0e06c4-dcea-414a-bf29-0b0758a3934b')=1 and
                        dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(@CURRENTAPPUSERID,'8DABE43F-6848-40EB-8638-8E4B6311CE72')=1 and
                        dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(@CURRENTAPPUSERID,'1A5D63F0-4DDD-4DD3-A4E6-FB1E9FE17FE2')=1 and
                        dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(@CURRENTAPPUSERID,'41B32DCD-4CFE-4FAC-83DA-FA9A3F893B71')=1 and
                        dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(@CURRENTAPPUSERID,'437cd7d8-e49c-4591-9574-572f5f15fd3a')=1 and
                        dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(@CURRENTAPPUSERID,'E1560C48-F5E0-4E4E-B9EF-9EE4CCE644F4')=1 and
                        dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(@CURRENTAPPUSERID,'08F40ECE-26B9-4e11-B53D-1FA5BAFC038A')=1 and
                        dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(@CURRENTAPPUSERID,'33EE2022-238B-4400-81F5-F81F19C9F755')=1 and
                        dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(@CURRENTAPPUSERID,'38B7BE1C-6F54-4951-94C5-EE53C688CBBA')=1 and
                        dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(@CURRENTAPPUSERID,'2dbf2cc3-958c-4454-b169-7eb1e656044e')=1 )
                        set @RE7SECURITYFEATURESGRANTED = 1;
                    else
                        set @RE7SECURITYFEATURESGRANTED = 0;    

         select top 1 @RE7CONFIGUREDFORUSER = 1
         from dbo.RE7INTEGRATIONCREDENTIALS
         where ID = @CURRENTAPPUSERID;

                  if dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 or
                      dbo.UFN_SECURITY_APPUSER_GRANTED_MAPENTITY_IN_SYSTEMROLE(@CURRENTAPPUSERID, '065A6FAB-669C-4032-B616-D57254F340AE') = 1
                      set @USER_GRANTED_MAPENTITY = 1;
                  else
                      set @USER_GRANTED_MAPENTITY = 0;    

                  if exists(select top 1 1 from dbo.MAPPINGCREDENTIALS where len([KEY]) > 0)
                      set @MAPPINGCREDENTIALSEXIST = 1;
                  else
                      set @MAPPINGCREDENTIALSEXIST = 0;    

                  set @NIGHTLYREFRESHENABLED = dbo.UFN_RESEARCHGROUP_NIGHTLYREFRESHENABLED()