Blitz Report Parameter Link Validation

Description

Categories
Enginatics
Repository
GitHub
Lists orphaned parameter rows: additional-anchor (sub) parameter rows - those without a display sequence - that do not link to a visible parameter of the same name in the same report (parameter_id not in xxen_report_parameters_link_v).

These are typically left behind by an incomplete parameter rename (e.g. 'Show DFF Attributes' to 'DFF Display'), leaving the old-named multi-anchor sub-rows dangling.

The run-time SQL is assembled solely from xxen_report_parameters_link_v, so an unlinked sub-row is never injected and is harmless at run time, but it clutters the parameter setup and would re-activate unexpectedly if a visible parameter with the old name were re-created.

Use the Category parameter to limit the scope.

SQL 22 lines

Parameters 1

ParameterTypeList of values SQL
CategoryLOV
xrpv.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
)