USP_WEBDASHBOARDPAGE_GETBYNAME

Gets a dashboard page by its name.

Parameters

Parameter	Parameter Type	Mode	Description
@NAME	nvarchar(200)	IN
@PATH	nvarchar(1000)	IN

Definition

Copy



CREATE procedure dbo.USP_WEBDASHBOARDPAGE_GETBYNAME(@NAME nvarchar(200), @PATH nvarchar(1000))
as
    set nocount on;

    select WEBDASHBOARDPAGECATALOG.ID,
        WEBDASHBOARDPAGECATALOG.NAME,
        WEBDASHBOARDPAGECATALOG.TITLE,
        WEBDASHBOARDPAGECATALOG.DESCRIPTION,
        WEBDASHBOARDPAGECATALOG.WEBDASHBOARDLAYOUTID,
        WEBDASHBOARDPAGECATALOG.CONTEXTRECORDTYPEID,
        RECORDTYPE.NAME CONTEXTRECORDTYPE,
        WEBDASHBOARDPAGECATALOG.CONTEXTRECORDSEARCHLISTCATALOGID,
        SEARCHLISTCATALOG.NAME CONTEXTRECORDSEARCHLIST,
        WEBDASHBOARDLAYOUT.CONTENTS
    from dbo.WEBDASHBOARDPAGECATALOG
        inner join dbo.WEBDASHBOARDLAYOUT on WEBDASHBOARDLAYOUT.ID = WEBDASHBOARDPAGECATALOG.WEBDASHBOARDLAYOUTID
        left join dbo.WEBDASHBOARDFOLDER on WEBDASHBOARDPAGECATALOG.WEBDASHBOARDFOLDERID = WEBDASHBOARDFOLDER.ID
        left join dbo.RECORDTYPE on WEBDASHBOARDPAGECATALOG.CONTEXTRECORDTYPEID = RECORDTYPE.ID
        left join dbo.SEARCHLISTCATALOG on WEBDASHBOARDPAGECATALOG.CONTEXTRECORDSEARCHLISTCATALOGID = SEARCHLISTCATALOG.ID
    where WEBDASHBOARDPAGECATALOG.NAME = @NAME and ((@PATH = '' and WEBDASHBOARDPAGECATALOG.WEBDASHBOARDFOLDERID is null) or WEBDASHBOARDFOLDER.PATH = @PATH);