Query for Task with candidate user and groups and includeAssignedTask filter

BerndVarga · April 21, 2020, 5:22am

Hi all,

I want to query for candidate user and groups within one query.

taskService.createTaskQuery()
.or()
.taskCandidateUser(teamUser)
.taskCandidateGroupIn(groups)
.endOr()
.includeAssignedTasks();

But this query throw a ProcessEngineException:
ProcessEngineException: Invalid query usage: candidateUser, candidateGroup, candidateGroupIn, withCandidateGroups, withoutCandidateGroups, withCandidateUsers, withoutCandidateUsers has to be called before ‘includeAssignedTasks’.

Is there a way to get the query running?
I want to avoid two separate queries.

Thanks, Bernd

aravindhrs · April 21, 2020, 7:52am

@BerndVarga, try the below one:

List<Task> taskList= taskService().createTaskQuery().includeAssignedTasks().or()
        .taskCandidateUser(teamUser).taskCandidateGroupIn(groups).endOr().list();

BerndVarga · April 22, 2020, 5:12am

Hi, thanks for response.

Still the same error:

ProcessEngineException: Invalid query usage: candidateUser, candidateGroup, candidateGroupIn, withCandidateGroups, withoutCandidateGroups, withCandidateUsers, withoutCandidateUsers has to be called before ‘includeAssignedTasks’.

github.com

camunda/camunda-bpm-platform/blob/master/engine/src/main/java/org/camunda/bpm/engine/impl/TaskQueryImpl.java#L482


    if (candidateUser != null || expressions.containsKey("taskCandidateUser")) {
      throw new ProcessEngineException("Invalid query usage: cannot set both candidateGroupIn and candidateUser");
    }
  }


  expressions.put("taskCandidateGroupIn", candidateGroupsExpression);
  return this;
}


@Override
public TaskQuery includeAssignedTasks() {
  if (candidateUser == null && candidateGroup == null && candidateGroups == null && !isWithCandidateGroups() && !isWithoutCandidateGroups() && !isWithCandidateUsers() && !isWithoutCandidateUsers()
      && !expressions.containsKey("taskCandidateUser") && !expressions.containsKey("taskCandidateGroup")
      && !expressions.containsKey("taskCandidateGroupIn")) {
    throw new ProcessEngineException("Invalid query usage: candidateUser, candidateGroup, candidateGroupIn, withCandidateGroups, withoutCandidateGroups, withCandidateUsers, withoutCandidateUsers has to be called before 'includeAssignedTasks'.");
  }


  includeAssignedTasks = true;
  return this;
}

Alvin.Q · September 14, 2021, 8:42am

.includeAssignedTasks() method must include in .or() and .endOr() statement

system · January 30, 2024, 12:20pm