Blitz Report Parameter Anchor Validation
Description
- Categories
- Enginatics
- Repository
- GitHub
Checks if all parameter anchors exist in the xxen_report_parameter_anchors table.
SQL 22 lines
select xrpv.report_name, xrpv.category, xrpv.display_sequence, xrpv.parameter_name, xrpv.anchor, xrpv.sql_text, (select count(*) from xxen_report_parameter_anchors xrpa where xrpv.report_id=xrpa.report_id) report_anchor_count, 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.report_id,xrpv.anchor) not in (select xrpa.report_id, xrpa.anchor from xxen_report_parameter_anchors xrpa) order by xrpv.report_name, xrpv.sort_order |
Parameters 1
| Parameter | Type | List of values SQL | |
|---|---|---|---|
| Category | LOV |
|