Blitz Report Dynamic Column Rules

Description

Categories: Enginatics
Repository: Github

Copy

select
xrdcr.rule_name,
xxen_util.yes(xrdcr.enabled) enabled,
xrv.report_name,
xrv.category,
xrv.type_dsp report_type,
(select count(*) from xxen_report_dyn_col_rule_rpts xrdcrr2 where xrdcrr2.rule_id=xrdcr.rule_id) report_count,
xrdcr.rule_sql,
xxen_util.user_name(xrdcrr.created_by) assigned_by,
xxen_util.client_time(xrdcrr.creation_date) assigned_date,
xxen_util.user_name(xrdcr.created_by) rule_created_by,
xxen_util.client_time(xrdcr.creation_date) rule_creation_date,
xxen_util.user_name(xrdcr.last_updated_by) rule_last_updated_by,
xxen_util.client_time(xrdcr.last_update_date) rule_last_update_date,
xrdcr.rule_id,
xrv.report_id
from
xxen_report_dynamic_col_rules xrdcr,
xxen_report_dyn_col_rule_rpts xrdcrr,
xxen_reports_v xrv
where
1=1 and
xrdcr.rule_id=xrdcrr.rule_id(+) and
xrdcrr.report_id=xrv.report_id(+)
order by
xrdcr.rule_name,
xrv.report_name

Parameter Name

SQL text

Validation

Rule Name

xrdcr.rule_name=:rule_name

LOV

Report Name

xrv.report_name=:report_name

LOV

Category

xrv.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
)