Hi:

I have one-to-many association between agency and agent entities, agency has a collection of agents.

I am trying to write an hql that would return me only active agencies, each having a collection of only active agents:



If an agency is active, it should be returned regardless whether it has qualifying agent or not. When run, the above hql returns only those agencies, whose agents meet the criteria "agent.deleted='N'", ignoring outer join clause when agents are missing or when they are inactive.

Please, help.

Thank you.

If you are outer joining on agent and there are no agents for the agency then by specifying:

in the clause is going to only select those agencies with agents - essentially undoing the work of your outer join.

You need to :
to include those without agents