USP_DATAFORMTEMPLATE_VIEW_ORGANIZATIONHIERARCHY

The load procedure used by the view dataform template "Organization Hierarchy View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@ORGANIZATIONNAME	nvarchar(100)	INOUT	Name
@ORGANIZATIONHIERARCHY	xml	INOUT	Hierarchy

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_ORGANIZATIONHIERARCHY
                    (
                        @DATALOADED bit = 0 output,
                        @CURRENTAPPUSERID uniqueidentifier,
                        @ORGANIZATIONNAME nvarchar(100) = null output,
                        @ORGANIZATIONHIERARCHY xml = null output
                    )
                    as
                    begin
                        set nocount on;
                        set @DATALOADED = 1;
                        set @ORGANIZATIONNAME = dbo.UFN_INSTALLATIONINFO_GETINSTALLATIONNAME();
                        set @ORGANIZATIONHIERARCHY = (
                                    select    ORGANIZATIONHIERARCHY.[ID], 
                                            ORGANIZATIONHIERARCHY.PARENTID,
                                            ORGANIZATIONHIERARCHY.[SEQUENCE],
                                            ORGANIZATIONPOSITION.NAME, 
                                            ORGANIZATIONPOSITION.SITEID,
                                                (select ORGANIZATIONPOSITIONHOLDER.ID, ORGANIZATIONPOSITIONHOLDER.CONSTITUENTID, ORGANIZATIONPOSITIONHOLDER.DATEFROM, ORGANIZATIONPOSITIONHOLDER.DATETO
                                                 from dbo.ORGANIZATIONPOSITIONHOLDER
                                                    where ORGANIZATIONPOSITIONHOLDER.POSITIONID = ORGANIZATIONPOSITION.ID
                                                 for xml raw('ITEM'),type,elements,root('POSITIONHOLDERS'),BINARY BASE64),
                                            dbo.UFN_SITEALLOWEDFORUSER(@CURRENTAPPUSERID, ORGANIZATIONPOSITION.SITEID) as USERHASSITEACCESS
                                     from dbo.ORGANIZATIONHIERARCHY
                                     left outer join dbo.ORGANIZATIONPOSITION
                                            on ORGANIZATIONPOSITION.ID = ORGANIZATIONHIERARCHY.ID
                                     for xml raw('ITEM'),type,elements,root('ORGANIZATIONHIERARCHY'),BINARY BASE64);


                        return 0;

                    end