USP_KPICATALOG_GETTREE

Gets a list of KPI catalog items to be displayed in a tree view.

Definition

Copy 


            create procedure dbo.USP_KPICATALOG_GETTREE
            as
                set nocount on;

                select KPICATALOG.ID,
                    KPICATALOG.NAME,
                    KPICATALOG.DESCRIPTION,
                    KPICATALOG.GOALTYPECODE,
                    KPICATALOG.UIFOLDER,
                    RECORDTYPE.NAME CONTEXTRECORDTYPE
                from dbo.KPICATALOG
                left join dbo.RECORDTYPE on KPICATALOG.CONTEXTRECORDTYPEID = RECORDTYPE.ID
                order by KPICATALOG.NAME;