USP_DATAFORMTEMPLATE_EDIT_RESEARCHGROUP2_LOAD

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@RECORDTYPEID	uniqueidentifier	INOUT
@NAME	nvarchar(100)	INOUT
@DESCRIPTION	nvarchar(255)	INOUT
@IDSETREGISTERID	uniqueidentifier	INOUT
@OWNERID	uniqueidentifier	INOUT
@OTHERSCANMODIFY	bit	INOUT
@OTHERSCANVIEW	bit	INOUT
@ALLOWREFRESH	bit	INOUT
@AUTOREFRESH	bit	INOUT
@POPULATEMETHODCODE	tinyint	INOUT
@CATEGORYCODEID	uniqueidentifier	INOUT
@SITES	xml	INOUT
@RESEARCHGROUPCRITERIA	xml	INOUT
@HASADMINRIGHTS	bit	INOUT
@NIGHTLYREFRESHENABLED	bit	INOUT
@INCLUDEATTRIBUTES	bit	INOUT

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_RESEARCHGROUP2_LOAD (
                        @ID uniqueidentifier,
                        @CURRENTAPPUSERID uniqueidentifier,
                        @DATALOADED bit = 0 output,
                        @TSLONG bigint = 0 output,
            @RECORDTYPEID uniqueidentifier = null output,
                        @NAME nvarchar(100) = null output,
                        @DESCRIPTION nvarchar(255) = null output,
                    @IDSETREGISTERID uniqueidentifier = null output,
            @OWNERID uniqueidentifier = null output,
                    @OTHERSCANMODIFY bit = null output,
                    @OTHERSCANVIEW bit = null output,
            @ALLOWREFRESH bit = null output,
            @AUTOREFRESH bit = null output,
            @POPULATEMETHODCODE tinyint = null output,
            @CATEGORYCODEID uniqueidentifier = null output,
                    @SITES xml = null output,
            @RESEARCHGROUPCRITERIA xml = null output,
            @HASADMINRIGHTS bit = null output,
            @NIGHTLYREFRESHENABLED bit = null output,
            @INCLUDEATTRIBUTES bit = null output
                    ) as
                        set nocount on;

                        set @DATALOADED = 0;

                        select
                            @DATALOADED = 1,
                            @TSLONG = RG.TSLONG,
                            @NAME = RG.NAME,
                            @DESCRIPTION = RG.DESCRIPTION,
                      @IDSETREGISTERID = IDSETREGISTERID,
              @OWNERID = OWNERID,
                      @OTHERSCANMODIFY = OTHERSCANMODIFY,
                      @OTHERSCANVIEW = OTHERSCANVIEW,
              @ALLOWREFRESH = ALLOWREFRESH,
              @AUTOREFRESH = AUTOREFRESH,
              @POPULATEMETHODCODE = POPULATEMETHODCODE,
              @CATEGORYCODEID = CATEGORYCODEID,
                            @SITES = dbo.UFN_RESEARCHGROUP_GETSITES_TOITEMLISTXML(RG.ID),
              @RESEARCHGROUPCRITERIA = dbo.UFN_RESEARCHGROUP_GETCRITERIA_TOITEMLISTXML(RG.ID),
              @HASADMINRIGHTS = dbo.UFN_RESEARCHGROUP_USERHASADMINRIGHTS(@ID, @CURRENTAPPUSERID),
              @INCLUDEATTRIBUTES = INCLUDEATTRIBUTES
                        from
                            dbo.RESEARCHGROUP RG
                        where
                            RG.ID = @ID;

            if @HASADMINRIGHTS = 0 
              set @HASADMINRIGHTS = dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID);

            if @HASADMINRIGHTS = 0 
              set @HASADMINRIGHTS = dbo.UFN_SECURITY_APPUSER_GRANTED_SYSTEMPRIVILEGE_IN_SYSTEMROLE(@CURRENTAPPUSERID,'5ff6322a-c325-40e3-8a20-320ca9365f5f');

                        select
                            @RECORDTYPEID = ID
                        from
                            dbo.RECORDTYPE
                        where
                            upper(NAME) = 'CONSTITUENT';

                        set @NIGHTLYREFRESHENABLED = dbo.UFN_RESEARCHGROUP_NIGHTLYREFRESHENABLED()

                        return 0;