Query processes by process variables

[tnfink]

Hi,

this is probably something I should solve by myself but after 3h of confusion I thought maybe someone did this already and could give me a hint.

What I like to do is query all the processes in jBPM to find some with a specific variable values. For example, find all processes with "customer=Smith".

This seems like a common use case but I do not find support in the API, I tried to create a Hibernate query but this seems to be not ease. The ProcessInstance is not directly linked to its variables. You have to find the context instance and then it seems that I also have to use the token.

So did someone already solved this and could give me a hint?

Thanks in advance.

-- Torsten

[tnfink]

Actually it is pretty simple. The data model in the Wiki helped a lot to see it.
Here is the query:

Query query = session.createQuery(
"select proc "
 + "from org.jbpm.graph.exe.ProcessInstance as proc, "
 + " org.jbpm.context.exe.VariableInstance as var "
 + "where var.processInstance = proc and "
 + " var.name = 'customer' and var.value = 'Smith'");

-- Torsten

[kukeltje]

and now some good indexes :-)