例如： 
查询已分配的任务和候选任务sql: 
SELECT DISTINCT 
CAST(pi.BUSINESSKEY AS SIGNED) AS businessKey 
FROM 
ACT_RU_TASK rt 
INNER JOIN ACT_RU_EXECUTION ru ON rt.EXECUTION_ID_ = ru.ID_ 
INNER JOIN ACT_HI_PROCINST pi ON ru.PROC_INST_ID_ = pi.ID_ 
WHERE 
SUBSTRING_INDEX(pi.PROC_DEF_ID_, ‘:’, 1) = ‘m_prepay_application_form’ 
AND ( 
rt.ASSIGNEE_ = 1486 – 已分配给你的任务 
OR EXISTS (-- 你是候选人的任务 
SELECT 1 FROM ACT_RU_IDENTI...