ok I got it, I think...here is a query using a view and joins on the view and the processinstance table to get the processinstance that is not done with given variables...using the results I can do another query to get the tasks as needed:
| select * from jbpm_variableinstance a, (select processinstance_ from | jbpm_variableinstance where name_ = 'XYZ' and stringvalue_ = '364834') subView, | jbpm_processinstance b | where a.processinstance_ = subView.processinstance_ | AND a.name_ = 'ABC' | AND subView.processinstance_ = b.id_ | AND b.end_ IS NULL; | WHERE I am doing a query based on two variables, one called XYZ with a value of 364834 and another variable called ABC. I guess one would have to create more views on the fly to get more data out based on a given variable name and value. Does this look to be the best way? Thanks, Julian View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3929961#3929961 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3929961 ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
