topic Re: retrieving task with variables values using single api call in Alfresco Archive

retrieving task with variables values using single api call

ganeshr — Mon, 21 Jan 2013 06:43:18 GMT

is it possible to get all tasks with variables names and values using TaskService Using the following service able to retrieve tasks but each task does not contain complete information like variables and its values. processEngine.getTaskService.createTaskQuery().list();Would like to know if the

Re: retrieving task with variables values using single api call

frederikherema1 — Mon, 21 Jan 2013 07:55:24 GMT

There is no single API call that can achieve this. You'll have to query the tasks first, and for each task, fetch the variables separately.

Re: retrieving task with variables values using single api call

ganeshr — Mon, 21 Jan 2013 08:19:11 GMT

but every of operation above goes to database. If I have list of 100 tasks I'll make 100 queries to DB. I don't want to use this approach. Is there any other way to get task variables?
can it be possible to customize the call?

Re: retrieving task with variables values using single api call

frederikherema1 — Mon, 21 Jan 2013 08:24:02 GMT

In the activiti-api, tasks are considered as light-weight objects, spawned by a process (or created by yourself). It was an explicit choice to keep them lightweight and excluding the properties all together. The NativeQuery won't work for you either because the TaskEntity doesn't contain any mappings for the properties.

If you want this in a single query, you'll have to write your own SQL and new mapping in iBatis OR alter the Task-entity and Task.xml mapping file, to include the variables…

Re: retrieving task with variables values using single api call

ganeshr — Mon, 21 Jan 2013 09:41:30 GMT

can you please share the path where these files are existing. Task-entity and Task.xml mapping files.
And how complexity is involved in changing this mapping files?

Re: retrieving task with variables values using single api call

frederikherema1 — Mon, 21 Jan 2013 09:45:11 GMT

modules/activiti-engine/src/main/resources/org/activiti/db/mapping/entity/Task.xml and modules/activiti-engine/src/main/java/org/activiti/engine/impl/persistence/entity/TaskEntity.java.

This will involve copying parts from the VariableInstance.xml mapping (or referencing result-mappings and queries from that file) in order to make the Task-queries in Task.xml, join in the variables as well… The other thing to do is to alter the result-mapping (resultMap id="taskResultMap") and TaskEntity, to add a map of variables to it.

More info on altering the myBatis mappings, can be found on google and myBatis docs, as this is not something Activiti-specific…