Blitz Reports and Example Files (Web View)

Description
Columns: Report Name, Web Report Name, Category, Example File Name, Creation Date, Created By ...
select
xwrv.report_name,
xwrv.web_report_name,
xwrv.category,
xwrv.example_file_name,
xwrv.creation_date,
xxen_util.user_name(xwrv.created_by) created_by
from
xxen_web_reports_v xwrv
where
1=1
order by
xwrv.report_name
Parameter Name SQL text Validation
Example File missing
xwrv.example_file_name is null
LOV
Category
xwrv.report_id in (
select
xrca.report_id
from
xxen_report_category_assigns xrca,
xxen_report_categories_v xrcv
where
xrcv.category=:category and
xrcv.category_id=xrca.category_id
)
LOV