Querying for a process state

[vittal.shenoy]

Hi,

How do I query the jBPM db to find out how many process instances are in a particular state ? E.g in a process definition like the one below, I want to find out all the process instances that are in "state1". Please let me know


<process-definition name="SIMLifeCycle" >
<start-state name="start">


</start-state>






<end-state name='end' />
</process-definition>

Thanks,
Vittal