I've got an object called ChangedSection that contains a Revision. The Revision contains a set of Statuses. A Status has a String that may be "Open" or "Closed".

I basically want all ChangedSections that contain a Revision with a status of open.

I want to do something like this:

from com.company.ChangedSection as changedSection where changedSection.revision.status.name='Open'

Is is possible to search for attributes contained within an object that is in a collection?

perhaps like this:

from com.company.ChangedSection as changedSection
join changedSection.revision as r
join r.statuses as s
where s.name='Open'

The join did the trick! Thanks!