[ ] Extend the historic process instance query (HistoricProcessInstanceQuery) with #affectedByBatch(String batchId) filter criteria
filter historic process instances which are related to job log with the given batchId
[ ] check if an index can be added to improve the query
[ ] Expose changes in REST API
[ ] document in OpenAPI
[ ] Expose the filter in Cockpit and add a deep link button on the Batches page that leads to the process dashboard where filter will be preselect to display the impacted process instances
query idea: SELECT from ACT_HI_PROCINST RES join ACT_HI_JOB_LOG JL where JL.batchId = param.batchId and RES.PROCESS_INSTANCE_ID_=JL.PROCESS_INSTANCE_ID_ - there will be more than one job log use the “exists” structure
Acceptance Criteria (Required on creation)
HistoricProcessInstanceQuery
) with#affectedByBatch(String batchId)
filter criteriabatchId
Hints
SELECT from ACT_HI_PROCINST RES join ACT_HI_JOB_LOG JL where JL.batchId = param.batchId and RES.PROCESS_INSTANCE_ID_=JL.PROCESS_INSTANCE_ID_
- there will be more than one job log use the “exists” structureorg.camunda.bpm.engine.history.HistoricProcessInstanceQuery
engine\src\main\resources\org\camunda\bpm\engine\impl\mapping\entity\HistoricProcessInstance.xml
org.camunda.bpm.engine.rest.dto.history.HistoricProcessInstanceQueryDto
AND
andOR
queries?Links
Breakdown
Dev2QA handover