I'm trying to adapt the StringVariablePersister presented in <a href="http://blog.athico.com/2009/09/drools-flow-variable-persistence.html">http://blog.athico.com/2009/09/drools-flow-variable-persistence.html</a><div><br>
</div><div><a href="http://blog.athico.com/2009/09/drools-flow-variable-persistence.html"></a>I can create process instances with variable "color":<br><div><br></div><div><div> private static WorkflowProcessInstance startProcess(StatefulKnowledgeSession ksession, String color) {</div>
<div> Map<String, Object> vars = new HashMap<String, Object>();</div><div> vars.put("color", color);</div><div> WorkflowProcessInstance p1 = (WorkflowProcessInstance) ksession.startProcess("com.sample.ruleflow", vars);</div>
<div> return p1;</div><div> }</div><div><br></div><div>I can count them:</div><div><br></div><div>select </div><div><div> count(*)</div><div>from </div><div> ProcessInstanceInfo</div><div><br></div><div>However I'm stymied as to counting process instances with a given color, as there appears to be no join column between ProcessInstanceInfo and VariableInstanceInfo.</div>
<div>Can such a query be written?</div><div><br></div><div>Thanks.</div><div><br></div><div><br></div><div><br></div></div></div></div>