Hi,

I have a Data Tbl and employee tbl.

Data Tbl:

Id.....employeeId..... data.....Status
1..... e_1...............abc.....Active
2..... e_1.......... ....xyz.....Inactive
3..... e_2...............123.....Active
4.....e_3...............123.....Inactive

Employee Tbl:

Id .....Name
e_1 .....J
e_2 .....K
e_3.....L

when i run the following query "select distinct e from Employee as e join e.datas as dt where dt.status='Active' order by e.Name asc" i correctly get only employees with active status, e1 & e2.

The issue i'm facing is if loop thro the above employee object ,say e_1 , my Data object is off size 2 instead of size1. any clue on solving it?

-thanks,
prakash,
UC davis

Try to use "join fetch" otherwise the data collection gets initialized by an extra query without the filter.

Hi,

Is the "fetch" keyword really necessary here?
I thought that it only specified "When" the data had to be extracted from the DB ...
Can it work using "join ... with" instead of "join ... where" in the below example?

hi,

the syntax "join fetch" did the trick. Thanks!

I tried the syntax "join.. with" instead of "join.. where" and it didn't apply the filter on the collections.

Thanks,
prakash