Consultar i eliminar workflows duplicats

delete_workflows_duplicats.sql

delete from wkf_workitem where id in (select min(wkd.id) from wkf_workitem wkd where wkd.inst_id in (select
    inst_id                                                                     
from                           
    wkf_workitem wki 
    JOIN wkf_instance ins ON ins.id = wki.inst_id 
group by                            
    inst_id, ins.res_id, ins.res_type, ins.uid  
having                   
    count(*) > 1
) and  wkd.state = 'complete' group by wkd.inst_id order by wkd.inst_id);

workflows_duplicats.sql

select  
    ins.res_id, ins.res_type, count(*), array_agg(wki.id) 
from                           
    wkf_workitem wki 
    JOIN wkf_instance ins ON ins.id = wki.inst_id 
group by                            
    ins.res_id, ins.res_type  
having                   
    count(*) > 1
;