I'm trying to get more power from the jBPM queries. Eg get all process instances in a specific workstep, or all instances with a specific variable set to something, etc. The default queries seem to be very limiting.
I tried to look into creating my own hibernate named queries, but no luck. Eg, I would need to get all ProcessInstances with a var pointing to a custom table where some condition in the custom table is met.
Any pointers or references to good resources that can help?
Here is an issue for query by variable.
But because we could store serializable object into database, so it is hard to query these variables. So could you have some advices on it?
And I think we could support querying process instance by activity name. Please open an issue for this. Thank you very much.