what is the advantage of combining it into one query compared to all the hassle you get into? The number and performance of the queries?
This my situation:
I have a processInstance which has a variable "objectId" which points to an id of an object in our domain model.
Now I want to query for all tasks for which the object's name referenced by "objectId" in the variables is a given value.
Any suggestions on how to do this without using a query on both our object's table and the task/variables table?
Iterating over all tasks, getting the objectId from the variables, quering the object and seeing if the name is what we are looking for, seems not to be the best way, don't you agree?
Maybe I'm overlooking some other solution?
Is a processinstance related to a unique objectID? If so use the businesskey. You can retrieve the processinstance by key and retrieve all tasks related to this instance
I have the same problem , I want to use appendOrderByClause(hql), but never execute this code in my program, I want to do my self method, where I can execute appendOrderByClause(hql) for ordered the group tasks correctly.
Does anyone know how?