I've the below sql query and I need corresponding hql.



Cost pool has a collection(sub_cost_pool) as a property. I need to filter the collection based on model_id
It should return one object with a filtered collection
I tried this



It didn't work...it was returning a list of 2 objects (1 costpool with unfiltered collection, 1 subcostpool).

Please help me. I already spent couple of hours on this. I tried using filters, it didn't help me.

Hi,

Can you post the hibernate mapping of the 2 classes?

Hey, I got the solution, there were two issues:
1. I was using hibernate 3.x which doesn't support with clause.
2. And it seems, hql doesn't support condition on fetching collections.

So, I upgraded to 3.5 and used filters on collection and it worked awesome..

Thanks overmeulen for replying.