topic Re: List Tasks a user has completed? in Alfresco Archive

List Tasks a user has completed?

roadtripryan — Tue, 11 Mar 2014 21:07:58 GMT

I can't quite figure this out. I have a process that a user completes a task on via:Claimed: taskService.claim(tasks.get(0).getId(), username);Completed: taskService.complete(taskId);I have history level at full, so expected to be able to do:historyService.createHistoricTaskInstanceQuery()

Re: List Tasks a user has completed?

trademak — Wed, 12 Mar 2014 12:21:01 GMT

Is this task part of a process definition?

Re: List Tasks a user has completed?

roadtripryan — Wed, 12 Mar 2014 14:50:52 GMT

Yes.

Re: List Tasks a user has completed?

roadtripryan — Wed, 12 Mar 2014 15:39:47 GMT

Ah, got it! I had changed the history level AFTER creating the process. Once I re-created the process with the history level at audit, it works.

However, I want to be able to do it using process variables:

List<HistoricTaskInstance> historicTasks = historyService.createHistoricTaskInstanceQuery()
                                .taskAssignee(username)
                                                        .processVariableValueEquals(ProcessVariablesEnum.PROCESS_ID.getName(), processId)

This is NOT working, even though the equivalent query for active tasks:

taskService.createTaskQuery()
                                .taskAssignee(username)
                                .processVariableValueEquals(ProcessVariablesEnum.PROCESS_ID.getName(), processId)

Works to get the task, then I complete it, and the equivalent history query does not work.

Is audit the history level that should work for keeping process and task variables? Or do I need to do full to get the history query to work with process variables? I see the history record in the database, so completing the task is working as expected.

Thanks.

Re: List Tasks a user has completed?

jbarrez — Mon, 17 Mar 2014 08:28:11 GMT

No, variable create/update is stored on ACTIVITY level, which is lower than AUDIT.

Do you see the variables in the historic variable table (ACT_HI_VARINST) ?