topic Re: Get all tasks along with all candidate users in Alfresco Archive

Get all tasks along with all candidate users

samantha — Fri, 10 Apr 2015 15:51:52 GMT

Hi,How to retrieve all tasks along with all candidate users attached to this task?Manage to retrieve all tasks like this: List<Task> taskLists=taskService.createTaskQuery().orderByTaskName().asc().list();I want to get all candidate users of each task. I will display it in a table (datatable pr

Re: Get all tasks along with all candidate users

trademak — Sun, 12 Apr 2015 07:51:13 GMT

That's not possible using the default query API, you would need to write a custom query for it.
If you create a JIRA we can look into supporting with the default query API.

Best regards,

Re: Get all tasks along with all candidate users

samantha — Mon, 13 Apr 2015 12:00:21 GMT

Ok I even write a custom query and yet I don't get the userId.

private static ManagementService managementService;

public static List<Task> retrieveAllTasks(){
    ProcessEngine processEngine = ProcessEngines.getDefaultProcessEngine();
    TaskService taskService = processEngine.getTaskService();

    String taskTable = managementService.getTableName(TaskEntity.class);
    String identityLinkTable = managementService.getTableName(IdentityLinkEntity.class);

    List<Task> tasksList = taskService.createNativeTaskQuery().sql("select _TASK.*" +
        " from " + taskTable + " _TASK" +
        " join " + identityLinkTable + " _LINK on _TASK.ID_ = _LINK.TASK_ID_" +
        " where _LINK.TYPE_ = 'candidate'").list();

return tasksList;

The same query when I execute it in sqldeveloper, I get all values. Why can't I get same in my list?
Glad if you can help.
Thanks

Re: Get all tasks along with all candidate users

jbarrez — Tue, 14 Apr 2015 12:36:16 GMT

Im assuming (not checked the code) it tries to map to a Task object here?
An alternative could be something like this: http://www.jorambarrez.be/blog/2014/01/17/execute-custom-sql-in-activiti/