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.
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
select xrpv.report_name, xrpv.category, xrpv.display_sequence, xrpv.parameter_name, xrpv.anchor, xrpv.sql_text, xxen_util.user_name(xrpv.created_by) created_by, xxen_util.client_time(xrpv.creation_date) creation_date, xxen_util.user_name(xrpv.last_updated_by) last_updated_by, xxen_util.client_time(xrpv.last_update_date) last_update_date, xrpv.report_id, xrpv.parameter_id from xxen_report_parameters_v xrpv where 1=1 and xrpv.parameter_id not in (select xrplv.parameter_id from xxen_report_parameters_link_v xrplv) order by xrpv.report_name, xrpv.parameter_name, xrpv.anchor |
Parameters 1
| Parameter | Type | List of values SQL | |
|---|---|---|---|
| Category | LOV |
|