Data Retention Rule containing Pipeline condition causes Impact Summary to fail

[stroomdev10]

Add a rule Pipeline is aPipelineName , press save, then hit the Impact Summary go button

You should get get a blank popup.

[at055612]

The following SQL will identify processor filters that use now unsupported term conditions on the Pipeline field

select
    p.id as processor_id,
    pf.id as filter_id,
    d.name as pipeline_name,
    pf.data as filter_xml
from processor_filter pf
inner join processor p on pf.fk_processor_id = p.id
inner join doc d on p.pipeline_uuid = d.uuid and d.ext = 'meta'
where ExtractValue(
    pf.data, 
    "count(/query/expression//term[./field='Pipeline' and (./condition='EQUALS' or ./condition='CONTAINS' or ./condition='IN' or ./condition='IN_DICTIONARY')])") > 0;

[at055612]

Fixed in v7.0.10