Blitz Report with only Filter in pivot table
Description
select xrtv.report_name, xrtv.template_name from xxen_report_template_pivot_v xrtpv, xxen_report_templates_v xrtv where xrtv.template_id=xrtpv.template_id and xrtpv.field_type='FILTER' and not exists ( select * from xxen_report_template_pivot_v xrtpv1 where xrtpv1.field_type<>'FILTER' and xrtpv1.template_id=xrtpv.template_id ) |