how to find processInstances by initiator?

[tsandor]

hi,
I'd like to ask a jbpm guru, to help me finding a method (in jbpm3.1.3) to list all running process instances that were started by a given swimlane (by a username). I found method only for getting taskInstances, but I'd like to see my processInstances even if they are assgined to someone else.

Thanks for help.
--
Thomas

[kukeltje]

uuhhhmmmm surprise. You couldn't find a method for this because there is none. You have to implement a hql for this yourself

[falazar]

We had to implement several of these functions, and finally had to go back down to the level of sql direct to get these kind of advanced queries, but it is really necessary for a nice display list for the inbox.

Another reason is the paging and sorting was not going well, so had to be pushed down to the sql level.

James