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 B04763D730F050D7E0530100007F06B3 Blitz Report Name (wildcard) 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 order by xrv.report_name US DBA78A51F3D1EE7DE0530100007FE998 select z.* from ( select y.*, nvl2(y.error_message,'Error','Valid') validation_result from ( select x.lov_name, x.report_name, x.parameter_name, xxen_report.validate_sql(replace(x.lov_query,':$flex$.',':'),'parse') error_message, x.lov_query from ( select xrpl.lov_name, null report_name, null parameter_name, xrpl.lov_query from xxen_report_parameter_lovs xrpl where 1=1 union all select null lov_name, xrpv.report_name, xrpv.parameter_name, xrpv.lov_query from xxen_report_parameters_v xrpv where 2=2 and xrpv.parameter_type='LOV' and xrpv.lov_id is null ) x ) y ) z where 3=3 order by z.lov_name Y US Blitz Report LOV SQL Validation Validates Blitz Report LOV SQLs for valid syntax. This can be useful after mass migrating reports from other tools such as Discoverer, Excl4apps, splashBI or Polaris Reporting Workbench into Blitz Report. Enginatics 1=1 2=2 3=3 1 10 1=1 lower(xrpl.lov_name) like lower(:lov_name_like) LOV Blitz Report Name (wildcard) B04763D730F050D7E0530100007F06B3 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 order by xrv.report_name F Nom LOV comme US LOV Name like 2 2=2 1=2 US LOV Name like 3 20 1=1 xrpl.lov_id in ( select xrp.lov_id from xxen_report_categories_v xrcv, xxen_report_category_assigns xrca, xxen_report_parameters xrp where xrcv.category=:category and xrcv.category_id=xrca.category_id and xrca.report_id=xrp.report_id and xrp.parameter_type='LOV' ) 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 F Catégorie US Category 4 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 ) US Category 5 30 1=1 xrpl.lov_id in (select xrpv.lov_id from xxen_report_parameters_v xrpv where lower(xrpv.report_name) like lower(:report_name_like) and xrpv.parameter_type='LOV') LOV Blitz Report Name (wildcard) B04763D730F050D7E0530100007F06B3 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 order by xrv.report_name US Report Name like 6 2=2 lower(xrpv.report_name) like lower(:report_name_like) US Report Name like 7 40 3=3 z.validation_result=:validation_result LOV custom Y select 'Valid' value, 'SQLs passing the validation' description from dual union all select 'Error' value, 'SQLs with error' description from dual F Résultat de la validation US Validation Result 779954859F98E2752C3D6A0481201B90 Default ENGINATICS 2 ERROR_MESSAGE 1 LOV_NAME 3 LOV_QUERY 4 VALIDATION_RESULT 1 Y S Site 779954859F98E2752C3D6A0481201B90