在查询当前用户的待办任务,包括本人就是处理人的或者还是候选人状态的任务时,方法为:
List<Task> list = taskService.createTaskQuery().taskCandidateOrAssigned(userId).
orderByTaskCreateTime().desc().list();
执行出现以下错误:
复制出来的完整sql为:
SELECT RES.*, VAR.ID_ as VAR_ID_, VAR.NAME_ as VAR_NAME_, VAR.TYPE_ as VAR_TYPE_, VAR.REV_ as VAR_REV_, VAR.PROC_INST_ID_ as VAR_PROC_INST_ID_, VAR.EXECUTION_ID_ as VAR_EXECUTION_ID_, VAR.TASK_ID_ as VAR_TASK_ID_, VAR.BYTEARRAY_ID_ as VAR_BYTEARRAY_ID_, VAR.DOUBLE_ as VAR_DOUBLE_, VAR.TEXT_ as VAR_TEXT_, VAR.TEXT2_ as VAR_TEXT2_, VAR.LONG_ as VAR_LONG_ FROM ( SELECT RES.* from ACT_RU_TASK RES WHERE (RES.ASSIGNEE_ = ?