TaskQuery to order by task variable

[ykphuah]

In my implementation, when I display the task list to the user, I need to present it with a lot of domain specific information, for example, a requestId field that I have put it in the task/process variable.

Is there a way to get TaskQuery to perform ordering by this variable?

I have all the information I need inside my own domain specific table, however, my own table do not contain the candidate information, so I need to use the taskCandidateOrAssigned and taskCandidateGroupIn from TaskQuery to perform the filtering of the requests for the specific user.

[jbarrez]

Hmm if the data lives in another table, then the default Activiti TaskQuery won't give you what you need (as it doesn't know that table).
A native query is probably the way to go.