CODEWITHSUNDEEP
taskactivitibusiness-process-management
Thien Dinh
Thien Dinh

Reputation: 373

Activiti BPM: How can I get list of deleted process instance (task)

How can I get list of deleted process instances (tasks). One way is to get the information for method getDeletedReason. However, do you have any other ways?

Upvotes: 0

Views: 924

Answers (1)

Vince
Vince

Reputation: 26

This sql query should give you all non completed historic instances without an active execution:

select h.proc_inst_id_ from act_hi_procinst h 
left join act_ru_execution x on x.proc_inst_id_ = h.proc_inst_id_ 
where h.end_act_id_ is null and x.proc_inst_id_ is null

Upvotes: 1

Related Questions