Hello

I work with criterias. How can I build a or-condition for two joins?

Example:



How can I create a or statement fort his two conditions?
I’d like to read all cities, which have a avenue, which accord to the avenueId or a building, which accord to the buildingId.

Thanks & sorry for my bad english!

Poffi

Hi

Criteria crit = session.createCriteria(City.class,"c");
.createCriteria("avenues","a")
.createCriteria("building","b")
.add(Restrictions.or(
Restrictions.eq("c.id", "a.avenueId"),
Restrictions.eq("c.id", "b.buildingId")
).list();


Always try to use aliases.

Amila

(Don't forget to rate if helps)

thanks for the answer. I couldn't test it allready (tomorrow), but i think this i not that, what I like to have.

Don't I need to write crit before:




Is this...

not a restriction for the city? I need a restriction for the set avenues and the set buildings. The query should read all cities which contains a building with the id buildingId or a avenue with the id anvenueId?


I think that could be the solution:


thanks!
poffi

If you don't care the performance, you can use 'outer join' by calling crit.createCriteria(blabla, Criteria.OUTER_JOIN);

Or you might use the SQL union, however, you will sacrifice code quality;

I got a very similar problem, and finally give up - Neither Bad performance nor bad code quality is accceptable for me .