Blitz Report Columns

➜ Back to Library
XLSExcel example XMLXML import file

Description

Categories
Enginatics
Repository
GitHub
Report showing all SQL columns of selected Blitz Reports by parsing their SQL on the fly.
Use the Category or Report Name parameters to scope the results. Running without filters will parse all enabled reports, which may take several minutes.

SQL 17 lines

select
xrv.report_name,
xxen_api.category(xrsc.id) category,
nvl(xrv.type_dsp,'Report') type,
xrsc.column_number,
xxen_report.column_translation(xrsc.column_name) column_header,
lower(xrsc.column_name) column_name,
xrsc.data_type
from
xxen_report_sql_columns xrsc,
xxen_reports_v xrv
where
1=1 and
xrsc.id=xrv.report_id
order by
xrv.report_name,
xrsc.column_number

Parameters 5

ParameterTypeList of values SQL
CategoryLOV
xrv.report_id in (
select
xrca.report_id
from
xxen_report_categories_v xrcv,
xxen_report_category_assigns xrca
where
xrcv.category=:category and
xrcv.category_id=xrca.category_id
)
Report TypeLOV
nvl(xrv.type_dsp,'Report')=:report_type
Report NameLOV
xrv.report_name=:report_name
Report Name likeLOV
xrv.report_name like :report_name_like
Column Header containsChar
lower(xxen_report.column_translation(xrsc.column_name)) like '%'||lower(:column_header)||'%'