grails « HQL « JPA Q&A





1. "NOT IN" with HQL and Grails    stackoverflow.com

The following query should select all organisations that are not in the excludedOrgs:

Organisation.findAll("from Organisation o where o not in elements(?)", 
    [excludedOrgs])
All I get is an org.springframework.orm.hibernate3.HibernateQueryException telling ...