topic How get task from business key in Alfresco Archive

How get task from business key

aram — Mon, 16 Apr 2012 07:48:03 GMT

Hi.I am using grails activity plugin. and I like to get all tasks for current document.to do that I define domain classes "Task" and "Execution" in grains and use following HQLgetTaskForDocument = from Task where id in( select id from Task where EXECUTION_ID_ in( select exec1.id from Execution exec1

Re: How get task from business key

ronald_van_kuij — Mon, 16 Apr 2012 17:40:12 GMT

Is there any other effective way to get Task using BUSINESS_KEY (I don't like to have/define "Task" and "Execution" domain classes in my app)?

Define effective… I just use the Activiti api and it performs well…

Re: How get task from business key

aram — Tue, 17 Apr 2012 10:56:06 GMT

using API I implement

public List<Task> getTasksFromDocumentID(String documentId) {
        List<Execution> executions = ActivitiUtils.getRuntimeService().createExecutionQuery()
                .variableValueEquals('businessKey', documentId)
                .orderByProcessInstanceId().desc().list();
        
        if (executions.size() > 0) {
            return ActivitiUtils.getTaskService().createTaskQuery()
                    .processInstanceId(executions.get(0)?.getProcessInstanceId())
                    .list();
        } else {
            return new ArrayList<Task>();
        }

    }

but here I have 2 querys. Is it possible to have only one query ?