删除
ACT_RU_TASK前需要先删除关联表
ACT_RU_VARIABLE
ACT_RU_IDENTITYLINK
以及没有外键关联关系的ACT_RU_EXECUTION表
比例是1 12 1 1
SELECT ID_ FROM ACT_RU_TASK WHERE EXECUTION_ID_ IN (
SELECT EXECUTION_ID_ FROM ACT_RU_VARIABLE
WHERE TEXT_ = ‘1455842496436371458’
)
SELECT EXECUTION_ID_ FROM ACT_RU_VARIABLE
WHERE TEXT_ IN (
SELECT id FROM jeecg-boot
.bi_plotplan
);