I've just written one of my first HQL-queries. It should look for such objects of Activity class (which contains list of objects of TodayEffort class) whose last item in todayEfforts-list has non-zero value of effort field.

But really it finds all objects of Activity class if last item in TODAY_EFFORT table has non-zero value of effort field, and doesn't find any objects otherwise.
Please help me to fix it

Hi!

I can't understand what's your final expectation....class Activity (A entity) has a list of class TodayEffort (B entity), you want to retrieve A instances whose property "effort" of last item of entities B related to A is not null...

Have you tried left outer joins, like "...on a.id = tes.activity" ?

AFAIU I can do it in standard SQL, but in HQL I have no access to "tes.activity" because tes (TodayEffort, B) doesn't have 'activity' field, this foreign key exists in the database only, class Activity doesn't have it therefore it's not mapped. I'd be happy if I had an access to foreign keys.

Let's say it in this way: There is a class A which contains a list of a class B. I want to get such instances of the class A which have such last items of their lists A.listOfB which have non-zero values of the field B.field1.
How can I do this?

Just want to add my mapping:

I solved the problem:

My main mistake of usage maxindex was that in the last condition I used tes instead of a.todayEfforts so I got errors. I don't know why it's so important. I'll be grateful if somebody tell me.