+ " and RES1.SUSPENSION_STATE_ = #{suspensionState}";
String sql = asigneeSql + " union all " + needClaimSql;
NativeTaskQuery query = taskService.createNativeTaskQuery().sql(sql)
.parameter("processDefinitionKey", "leave-formkey").parameter("suspensionState", SuspensionState.ACTIVE.getStateCode())
.parameter("userId", user.getId());
List<Task> tasks = query.listPage(pageParams[0], pageParams[1]);
page.setResult(tasks);
page.setTotalCount(query.sql("select count(*) from (" + sql + ") as CT").count());
mav.addObject("page", page);
return mav;