根据用户ID和租户ID查询未完成BPM任务的SQL语句解析

这个SQL查询是根据用户ID和租户ID查询未完成且未锁定的BPM任务。首先从BPM_TASK表中查询ASSIGNEE_为给定用户ID、TENANT_ID_为给定租户ID、且STATUS_不等于"COMPLETED"和"LOCKED"的记录。然后从bpm_task表中查询ASSIGNEE_为空、STATUS_不等于"COMPLETED"和"LOCKED"、且USER_ID_为给定用户ID且TENANT_ID_为给定租户ID或GROUP_ID_在给定组ID集合中的记录。最后对这两个结果集进行UNION操作，并根据可选的where条件和排序条件进行过滤和排序。\n\n\n select v.* from (\n select t.* from BPM_TASK t left join bpm_def d on t.def_id_= d.def_id_ where ASSIGNEE_=#{userId} and t.TENANT_ID_=#{tenantId} and t.STATUS_!='COMPLETED' and t.STATUS_!='LOCKED'\n UNION\n select t.* from bpm_task t left join bpm_def d on t.def_id_= d.def_id_ left join bpm_task_user u on\n t.TASK_ID_=u.TASK_ID_\n where t.ASSIGNEE_ is null AND t.STATUS_!='COMPLETED' and t.STATUS_!='LOCKED' and (u.USER_ID_=#{userId} and t.TENANT_ID_=#{tenantId}\n or u.GROUP_ID_ in\n #{id}\n \n )\n ) v where 1=1\n \n and ${w.whereSql}\n \n \n ORDER BY ${w.orderBySql}\n \n