USP_DATALIST_SITEHIERARCHY

List of all sites in the system in a hierarchical format.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_SITEHIERARCHY(@CURRENTAPPUSERID uniqueidentifier = null)
                as 

                    set NOCOUNT on;

                    select 
                        SITE.ID,
                        SITE.NAME,
                        SITE.DESCRIPTION,
                        (select PARENTSITE.ID from dbo.SITE as PARENTSITE where PARENTSITE.HIERARCHYPATH = SITE.HIERARCHYPATH.GetAncestor(1)) as PARENTID    
                    from 
                        dbo.site
          inner join dbo.UFN_SITESFORUSER(@CURRENTAPPUSERID) SITESFORUSER on SITE.ID = SITESFORUSER.SITEID 
                    order by 
                        HIERARCHYPATH;