USP_DATAFORMTEMPLATE_EDITLOAD_SYSTEMROLEADGROUP2

The load procedure used by the edit dataform template "System Role Group Edit Form 2"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@GROUPID	varbinary	INOUT	GroupID
@LDAPQUERY	nvarchar(max)	INOUT	LDAP query
@DISPLAYNAME	nvarchar(255)	INOUT	Display Name
@SEARCHROOT	nvarchar(1024)	INOUT	Search Root
@INCLUDESUBCONTAINERS	bit	INOUT	Search for users in subcontainers
@SECURITYMODECODE	tinyint	INOUT	Record access
@SITEHIERARCHY	xml	INOUT	Hierarchy
@SITES	xml	INOUT	Sites
@OVERWRITEEXISTINGSECURITY	bit	INOUT	Overwrite existing security settings
@BRANCHSITEID	uniqueidentifier	INOUT	Branch
@CONSTITUENTSECURITYMODECODE	tinyint	INOUT	Record access
@CONSTITUENTSECURITYGROUPS	xml	INOUT	Constituent security groups

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_SYSTEMROLEADGROUP2 
                    (
                        @ID uniqueidentifier,
                        @DATALOADED bit = 0 output,
                        @TSLONG bigint = 0 output,
                        @GROUPID varbinary(85) = null output,
                        @LDAPQUERY nvarchar(max) = null output,
                        @DISPLAYNAME nvarchar(255) = null output,
                        @SEARCHROOT nvarchar(1024) = null output,
                        @INCLUDESUBCONTAINERS bit = null output,
                        @SECURITYMODECODE tinyint = null output,
                        @SITEHIERARCHY xml = null output,
                        @SITES xml = null output, 
                        @OVERWRITEEXISTINGSECURITY bit = null output,
                        @BRANCHSITEID uniqueidentifier = null output,
                        @CONSTITUENTSECURITYMODECODE tinyint = null output,
                        @CONSTITUENTSECURITYGROUPS xml = null output
                    )    
                    as
                        set nocount on;

                        select
                            @SITEHIERARCHY = (
                                select 
                                    SITE.ID as SITEID, 
                                    (select 
                                        PARENTSITE.ID 
                                    from 
                                        dbo.SITE AS PARENTSITE 
                                    where 
                                        SITE.HIERARCHYPATH.GetAncestor(1) = PARENTSITE.HIERARCHYPATH
                                    ) as PARENTSITEID, 
                                    SITE.NAME, 
                                    row_number() over (partition by SITE.HIERARCHYPATH.GetAncestor(1) order by HIERARCHYPATH) as SEQUENCE,
                                    isnull(
                                        (select 
                                            SYSTEMROLEADGROUPSITE.ID 
                                        from 
                                            dbo.SYSTEMROLEADGROUPSITE 
                                        where 
                                            SYSTEMROLEADGROUPSITE.SITEID = SITE.ID and 
                                            SYSTEMROLEADGROUPSITE.SYSTEMROLEADGROUPID = @ID
                                        ), 
                                        newid()
                                    ) as SYSTEMROLEADGROUPSITEID
                                from 
                                    dbo.SITE 
                                order by 
                                    HIERARCHYPATH
                                for
                                    xml raw('ITEM'),type,elements,root('SITEHIERARCHY'),BINARY BASE64
                            );

                        set @DATALOADED = 0;
                        set @TSLONG = 0;

                        select
                            @DATALOADED = 1,
                            @GROUPID = SYSTEMROLEADGROUP.GROUPID,
                            @LDAPQUERY = SYSTEMROLEADGROUP.LDAPQUERY,
                            @DISPLAYNAME = SYSTEMROLEADGROUP.DISPLAYNAME,
                            @SEARCHROOT = SYSTEMROLEADGROUP.SEARCHROOT,
                            @INCLUDESUBCONTAINERS = SYSTEMROLEADGROUP.INCLUDESUBCONTAINERS,
                            @SECURITYMODECODE = SYSTEMROLEADGROUP.SECURITYMODECODE,
                            @SITES = dbo.UFN_SYSTEMROLEADGROUP_GETSITES_TOITEMLISTXML(SYSTEMROLEADGROUP.ID),
                            @CONSTITUENTSECURITYGROUPS = dbo.UFN_SYSTEMROLEADGROUP_GETSECURITYGROUPS_TOITEMLISTXML(SYSTEMROLEADGROUP.ID),
                            @TSLONG = SYSTEMROLEADGROUP.TSLONG, 
                            @OVERWRITEEXISTINGSECURITY = SYSTEMROLEADGROUP.OVERWRITEEXISTINGSECURITY,
                            @BRANCHSITEID = SYSTEMROLEADGROUP.BRANCHSITEID,
                            @CONSTITUENTSECURITYMODECODE = SYSTEMROLEADGROUP.CONSTITUENTSECURITYMODECODE
                        from 
                            dbo.SYSTEMROLEADGROUP 
                        where 
                            SYSTEMROLEADGROUP.ID = @ID;

                        return 0;