V_SEARCH_DESIGNATIONHIERARCHY

Search screen for finding hierarchies.

Fields

Field	Field Type	Null
ID	uniqueidentifier
NAME	nvarchar(100)
TYPE	nvarchar(100)	yes
CATEGORY	nvarchar(100)	yes
USERID	nvarchar(100)
DESIGNATIONREPORT1CODEID	uniqueidentifier	yes
DESIGNATIONREPORT2CODEID	uniqueidentifier	yes
SITE	nvarchar(250)	yes

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  9/1/2024 11:54:13 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3800.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SEARCH_DESIGNATIONHIERARCHY AS



                select DESIGNATIONLEVEL.ID,
                    DESIGNATIONLEVEL.NAME,
                    DESIGNATIONLEVELTYPE.DESCRIPTION [TYPE],
                    DESIGNATIONLEVELCATEGORYCODE.DESCRIPTION [CATEGORY],
                    DESIGNATIONLEVEL.USERID,
                    DESIGNATIONLEVEL.DESIGNATIONREPORT1CODEID,
                    DESIGNATIONLEVEL.DESIGNATIONREPORT2CODEID,
                    SITE.NAME [SITE]
                from dbo.DESIGNATIONLEVEL
                left join dbo.DESIGNATIONLEVELCATEGORYCODE on DESIGNATIONLEVEL.DESIGNATIONLEVELCATEGORYCODEID = DESIGNATIONLEVELCATEGORYCODE.ID
                left join dbo.SITE on DESIGNATIONLEVEL.SITEID = SITE.ID
                left join dbo.DESIGNATIONLEVELTYPE on DESIGNATIONLEVEL.DESIGNATIONLEVELTYPEID = DESIGNATIONLEVELTYPE.ID
                where 
                    EXISTS(SELECT ID FROM dbo.DESIGNATION WHERE DESIGNATIONLEVEL1ID = DESIGNATIONLEVEL.ID)
                ;