USP_DATAFORMTEMPLATE_ADD_SYSTEMROLEADGROUP_PRELOAD

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

Parameters

Parameter	Parameter Type	Mode	Description
@SYSTEMROLEID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@SITEHIERARCHY	xml	INOUT	Hierarchy

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_SYSTEMROLEADGROUP_PRELOAD
                    (
                        @SYSTEMROLEID uniqueidentifier,
                        @SITEHIERARCHY xml = null output
                    )
                    as
                    begin
                        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,
                                    newid() as SYSTEMROLEADGROUPSITEID
                                from 
                                    dbo.SITE 
                                order by 
                                    HIERARCHYPATH
                                for
                                    xml raw('ITEM'),type,elements,root('SITEHIERARCHY'),BINARY BASE64
                            )
                    end