Hi all, I use JBoss 4.2.0 + jBPM 3.2.1 + Hibernate 3 with a PostgreSQL 8.2.4 database. I'd like to perform an HQL query which could generate the following SQL query :
select name_, version_ from jbpm_processdefinition d1 where not exists (select name_, version_ from jbpm_processdefinition d2 where d2.name_ = d1.name_ and d2.version_ = d1.version_ +1) Is there a way to do that ? select d1.name, d1.version from ProcessDefinition d1 where not exist (select d2.name, d2.version from ProcessDefinition d2 where d2.name = d1.name and d2.version = d1.version+1) doesn't work. Regards A. ROY View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4080731#4080731 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4080731 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user