processEngine.getRuntimeService().createProcessInstanceQuery().processInstanceId(“ 132501”).active().singleResult();

JAVA:

processEngine.getRuntimeService().createProcessInstanceQuery().processInstanceId(“ 132501”).active().singleResult();

SQL:

SELECT DISTINCT
	RES.*,
	P.KEY_ AS ProcessDefinitionKey,
	P.ID_ AS ProcessDefinitionId,
	P.NAME_ AS ProcessDefinitionName,
	P.VERSION_ AS ProcessDefinitionVersion,
	P.DEPLOYMENT_ID_ AS DeploymentId
FROM
	ACT_RU_EXECUTION RES
INNER JOIN ACT_RE_PROCDEF P ON RES.PROC_DEF_ID_ = P.ID_
WHERE
	RES.PARENT_ID_ IS NULL
AND RES.ID_ = “132501”
AND RES.PROC_INST_ID_ = “132501”
AND (RES.SUSPENSION_STATE_ = 1)
ORDER BY
	RES.ID_ ASC
LIMIT 2147483647 OFFSET 0
原文地址:https://www.cnblogs.com/jimboi/p/8052794.html