USP_DATALIST_DASHBOARDDATALISTS

CREATE procedure dbo.USP_DATALIST_DASHBOARDDATALISTS
(
    @DASHBOARDID uniqueidentifier
)
as
    set nocount on;

    with xmlnamespaces ('bb_appfx_datalist' as tns, 'bb_appfx_commontypes' as common)
    select 
        D.ID,
        D.UINAME as NAME,
        D.DESCRIPTION,
        D.DATALISTSPEC.value('(tns:DataListSpec/@Author)[1]', 'nvarchar(500)') as AUTHOR,
        RT.NAME as RECORDTYPE,
        dbo.UFN_INSTALLEDPRODUCTS_OPTIONALPRODUCTSINSTALLED(D.DATALISTSPEC.query('tns:DataListSpec/common:InstalledProductList')) as INSTALLED
    from dbo.DATALISTCATALOG as D
        inner join dbo.UFN_DASHBOARD_DATALISTREFERENCES(@DASHBOARDID) as T on D.ID = T.DATALISTID
        left join dbo.RECORDTYPE as RT on D.RECORDTYPEID = RT.ID
    order by D.UINAME;