USP_QUERYVIEW_GETMETADATA

CREATE procedure dbo.USP_QUERYVIEW_GETMETADATA
(
  @ID uniqueidentifier
)
with execute as caller
as begin
  set nocount on;

  select
    [QUERYVIEWCATALOG].[ID],
    [QUERYVIEWCATALOG].[OBJECTNAME],
    [QUERYVIEWCATALOG].[DISPLAYNAME],
    [QUERYVIEWCATALOG].[RECORDTYPEID],
    [RECORDTYPE].[NAME] as [RECORDTYPE],
    [QUERYVIEWCATALOG].[OBJECTTYPE],
    [QUERYVIEWCATALOG].[ROOTOBJECT],
    [QUERYVIEWCATALOG].[SUBGROUP],
    [QUERYVIEWCATALOG].[OUTPUTDEFINITIONXML],
    [QUERYVIEWCATALOG].[PARAMETERMETADATAXML],
    [QUERYVIEWCATALOG].[QUERYVIEWSPEC],
    [QUERYVIEWCATALOG].[QUERYVIEWSPECEXTENSION],
    (select count(*) from dbo.[QUERYVIEWRELATIONSHIP] where [ROOTQUERYVIEWID] = [QUERYVIEWCATALOG].[ID]) as [CHILDNODECOUNT],
    [QUERYVIEWCATALOG].[TSLONG],
    [QUERYVIEWCATALOG].[DATECHANGED],
    cast(isnull([OLAPDATASOURCE].[SUPPORTSROLLINGDATES], 0) as bit) as [SUPPORTSROLLINGDATES],
    dbo.UFN_OLAP_GETDATAMARTLASTREFRESH_FROMDATASOURCE([OLAPDATASOURCE].[ID]) as [DATAMARTLASTREFRESH]
  from dbo.[QUERYVIEWCATALOG]
  left outer join dbo.[RECORDTYPE] on [QUERYVIEWCATALOG].[RECORDTYPEID] = [RECORDTYPE].[ID]
  left outer join dbo.[OLAPDATASOURCE] on [OLAPDATASOURCE].[MARTKEY] = [QUERYVIEWCATALOG].[MARTKEY]
  where [QUERYVIEWCATALOG].[ID] = @ID;

  return 0;
end