Using querydsl how can I check against a specific object from a set of objects that result from a One to Many relationship?

java jpa querydsl
codeLes picture codeLes · Jun 1, 2012 · Viewed 7.7k times · Source

I have a Person JPA entity, and my Person has multiple addresses (OneToMany relationship from Person to Address). I want to be able to do a query for all people that have a particle zipcode but I'm not sure after looking at the querydsl documentation how to properly handle the collection.

I can access the addresses but I'm not sure what to do with them:

QPerson qPerson = QPerson.person;
personDao.findAll(qPerson.addresses._SPECIFICADDRESS_.zip.eq('73130'));

How can I get the SPECIFICADDRESS I'm looking for?

Answer

Timo Westkämper picture Timo Westkämper · Jun 2, 2012

Try this

QPerson qPerson = QPerson.person;
personDao.findAll(qPerson.addresses.any().zip.eq('73130'));

Related questions

QueryDSL returning max value

I want to return the max value using QueryDSL. With this query I return the interval which eventid is equal to id and it is working properly. QInterval interval = QInterval.interval; JPAQuery query = new JPAQuery(em); BooleanExpression checkId = interval.event.…

Read More
How to call mysql function using querydsl?

I am in little hurry so, i just want to ask a quick question about querydsl. According to my research, query dsl doesn't support stored procedure but can support database functions. My Question is how can we invoke those database …

Read More
left join with spring data jpa and querydsl

I am using spring data jpa and querydsl and trapped on how to write simple nice query to left join two tables. Suppose I have an Project entity and a Task entity with OneToMany relationship defined in Project, I would …

Read More