Hibernate version: 2.1.8

Name and version of the database you are using: Postgresql 8.0

I'm struggling with an HQL aggregate issue and I can't seem to solve it :-

I've got a crime record with a one to many associated of notifications. A notification has a property - userAcknowledged. I'm trying to select out the count of crime records that have one or more attached notifications with the user acknowledged flag set. Even the total number of unacknowledged attached notifications would do if thats easier!

I've got something like :-

select count(crRec) from CrimeRecord crRec where crRec.attachedNotifications = some ("
select crRec.attachedNotifications from CrimeRecord crRec where crRec.attachedNotifications.userAcknowledged ='0')

However, the syntax is eluding me.

Can anyone help!?

Thanks!,

Rob Kirkbride

Should be something like this:

Thanks that solved it!

Rob