I would like to return the count of a parent class whose children all
have 'true' for a given property.

I'm not quite sure how to do this, this is my attempt so far:

Caused by: net.sf.hibernate.QueryException: outer or full join must be followed by path expression [SELECT count(rp) FROM ReviewPart rp INNER JOIN PriceChange pc WHERE rp.review = :review AND pc.competitive = true AND pc.withinBounds = true AND pc.interchangeCompliant = true Group By rp]

In short, I would like the Parent's state to be a reflection of the collective state of the children. On a per-parent basis, this is easy with iteration.