ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEFA79D2E0530100007F1FF2 Blitz Report Category Y select xrcv.category value, (select count(*) from xxen_report_category_assigns xrca where xrcv.category_id=xrca.category_id) description from xxen_report_categories_v xrcv order by xrcv.category US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 045BF0895C3A2865E0630100007F0617 select z.* from ( select xrpv.report_name, xrpv.category, xrpv.display_sequence, xrpv.parameter_name, xrpv.anchor, xxen_api.bindvar_name(xrpv.parameter_id) bindvar_name, xxen_report.is_select_(xrpv.sql_text) is_dynamic_sql_text, xrpv.sql_text, y.binds, y.bind_count, xrpv.parameter_id from xxen_report_parameters_v xrpv, ( select distinct x.parameter_id_display, count(*) over (partition by x.parameter_id_display) bind_count, listagg(x.bind,', ') within group (order by x.bind) over (partition by x.parameter_id_display) binds from ( select distinct xrplv.parameter_id_display, lower(dbms_lob.substr(regexp_substr(xrplv.sql_text,':\w+',1,rowgen.column_value))) bind from (select xrplv.parameter_id_display, xxen_report.clear_text(xrplv.sql_text) sql_text from xxen_report_parameters_link_v xrplv where 1=1) xrplv, table(xxen_util.rowgen(regexp_count(xrplv.sql_text,':\w+'))) rowgen ) x ) y where 2=2 and xrpv.display_sequence is not null and xrpv.parameter_id=y.parameter_id_display ) z where 3=3 order by z.report_name, z.display_sequence Y US Blitz Report Parameter Bind Variable Validation This report can be used to check which :bind variables were assigned to which Blitz Report parameter, in case there are more than one :binds in the parameter sql text, or in case the same :bind variable name is incorrectly used in different parameters. Enginatics 1=1 2=2 3=3 1 10 2=2 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 ) LOV Blitz Report Category 8E2FF36EDEFA79D2E0530100007F1FF2 Y select xrcv.category value, (select count(*) from xxen_report_category_assigns xrca where xrcv.category_id=xrca.category_id) description from xxen_report_categories_v xrcv order by xrcv.category Discoverer US Category 2 1=1 xrplv.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 ) US Category 3 20 2=2 xrpv.report_id not in ( select xrca.report_id from xxen_report_category_assigns xrca, xxen_report_categories_v xrcv where xrcv.category=:category_is_not and xrcv.category_id=xrca.category_id ) LOV Blitz Report Category 8E2FF36EDEFA79D2E0530100007F1FF2 Y select xrcv.category value, (select count(*) from xxen_report_category_assigns xrca where xrcv.category_id=xrca.category_id) description from xxen_report_categories_v xrcv order by xrcv.category US Category is not 4 1=1 xrplv.report_id not in ( select xrca.report_id from xxen_report_category_assigns xrca, xxen_report_categories_v xrcv where xrcv.category=:category_is_not and xrcv.category_id=xrca.category_id ) US Category is not 5 30 2=2 xrpv.report_name=:report_name LOV custom Y select xrv.report_name value, xrv.type_dsp||nvl2(xrv.type,' ',null)||nvl2(xrv.category,'('||xrv.category||') ',null)||substrb(xrv.description,1,4000-lengthb(xrv.type_dsp||nvl2(xrv.type,' ',null)||nvl2(xrv.category,'('||xrv.category||') ',null))) description from xxen_reports_v xrv where xrv.report_id in (select xrp.report_id from xxen_report_parameters xrp where xrp.parameter_id in (select xrpdv.parameter_id from xxen_report_param_default_vals xrpdv)) order by xrv.report_name US Report Name 6 1=1 xrplv.report_id in (select xrv.report_id from xxen_reports_v xrv where xrv.report_name=:report_name) US Report Name 7 40 3=3 z.bindvar_name is null LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Parameters with missing :binds 8 50 2=2 y.bind_count>1 LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Parameters with multiple :binds