Blitz Report Columns

➜ Back to Library
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.
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
Parameter NameSQL textValidation
Category
xrv.report_id in (
select
xrca.report_id
from
xxen_report_categories_v xrcv,
xxen_report_category_assigns xrca
where
xrcv.category=:p_category and
xrcv.category_id=xrca.category_id
)
LOV
Report Type
nvl(xrv.type_dsp,'Report')=:p_report_type
LOV
Report Name
xrv.report_name=:p_report_name
LOV
Report Name like
xrv.report_name like :p_report_name_like
LOV
Column Header contains
lower(xxen_report.column_translation(xrsc.column_name)) like '%'||lower(:p_column_header)||'%'
Download
Related Blitz Reports
Blitz Report Text Search Blitz Reports Blitz Upload Dependencies Blitz Upload Data RWB Execution History RWB Reports Blitz Report SQL Validation Blitz Report Security Blitz Upload History
Blitz Report™