nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

How get task from business key

aram

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 HQL

getTaskForDocument = from Task 
where id in( 
select id from Task where EXECUTION_ID_ in( 
select exec1.id from Execution exec1 where 
exec1.BUSINESS_KEY_=:BUSINESS_KEY and 
exec1.id in( select max(id) from Execution as exec2 where exec2.BUSINESS_KEY_ = exec1.BUSINESS_KEY_ )))
‍‍‍‍‍‍‍‍

List tasksForDocument = Task.findAll(getTaskForDocument, [BUSINESS_KEY: "BUSINESS_KEY_here"]);

‍‍‍‍

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)?

Find more posts tagged with

Comments

ronald_van_kuij

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…

aram

using API I implement

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

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