Select Tasks With Variables In Single Query

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

maier

Hi everybody,

is there a way to get a list of tasks with its variables in one query? Of course, I can get the required data the following way (example):

List<Task> tasks = taskService.createTaskQuery().taskAssignee("mike").list();
for (Task task: tasks) {
  Map<String, Object> vars = taskService.getVariables(task.getId());
  System.out.println(task.getId() + " - " + task.getDueDate() + " - " + vars.get("var1") + " - " + vars.get("var2"));
}
‍‍‍‍‍‍‍

I don't really like that solution since there has to be done a seperate query task for each task which might cause a lot of single database queries… I would prefer if the variable map would be directly provided with the task:

List<Task> tasks = taskService.createTaskQuery().taskAssignee("mike").list();
for (Task task: tasks) {
  Map<String, Object> vars = task.getVariables();
  System.out.println(task.getId() + " - " + task.getDueDate() + " - " + vars.get("var1") + " - " + vars.get("var2"));
}
‍‍‍‍‍‍‍

But since this is not possible: Is there already another way I could handle my issue?

Thank You!
Mike

frederikherema1

I'm afraid this is not possible in one go at the moment, and nothing planned to expose this (would require change of task model API, exposing variables). You can leverage the paging to get a limited list of tasks for which you get the vars in a different query.

You can also limit the results based on task-variable values if you want… (tQuery.taskVariariableValueEquals(…))