USP_DATALIST_ADHOCQUERYREPORT

Provides a list of reports that were created from an ad-hoc query.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_ADHOCQUERYREPORT(@CURRENTAPPUSERID uniqueidentifier)
                as
                    set nocount on;
                        with xmlnamespaces('bb_appfx_report' as ns, 'bb_appfx_commontypes' as c)
                    select 
                        REPORTCATALOG.ID, 
                        REPORTCATALOG.UINAME as [NAME], 
                        REPORTCATALOG.[DESCRIPTION]
                    from 
                        dbo.REPORTCATALOG
                    where
                        REPORTCATALOG.REPORTSPECXML.value('ns:ReportSpec[1]/c:MetaTags[1]/AdHocQuerySaveReportRequest[1]', 'nvarchar(max)') is not null
                    order by
                        REPORTCATALOG.UINAME;