USP_DATALIST_DATALISTDASHBOARDREFERENCES

Displays information about the dashboards that use the given data list.

Parameters

Parameter	Parameter Type	Mode	Description
@DATALISTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



create procedure dbo.USP_DATALIST_DATALISTDASHBOARDREFERENCES
(
    @DATALISTID uniqueidentifier
)
as
    set nocount on;

    select distinct
        D.ID,
        D.NAME,
        D.DESCRIPTION,
        R.NAME as RECORDTYPE
    from dbo.DASHBOARDCATALOG as D
        inner join dbo.UFN_DATALIST_DASHBOARDREFERENCES(@DATALISTID) as T on D.ID = T.DASHBOARDID
        left join dbo.RECORDTYPE as R on D.CONTEXTRECORDTYPEID = R.ID
    order by D.NAME;