ENGINATICS
SYSTEM_ADMINISTRATOR
SYSADMIN
1971215DD157CBE9E06362FB09053507Y
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
)
US
Blitz Report with only Filter in pivot table