Hibernate Community • View topic

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Query question

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

andkjo

Post subject: Query question

Posted: Thu Mar 26, 2009 7:12 pm

Newbie

Joined: Thu Mar 26, 2009 6:59 pm
Posts: 1

Hi

I have a domain object Customer that contains a list of CustomerEvent objects in a List named customerEvents. A CustomerEvent has a field called "type"

I would like to query for all Customers that has at least one CustomerEvent that has its type set to a spesific value.

How do I do this in HQL? I've scanned the documentatjon, but I don't seem to find the correct query? Do I have to use a an explicit join, or are there shortcuts? How should I write the query?

Br,
Anders

Top

nordborg

Post subject:

Posted: Fri Mar 27, 2009 3:00 am

Expert

Joined: Wed Mar 03, 2004 6:35 am
Posts: 1240
Location: Lund, Sweden

Something like the following HQL should work:

Code:

select distinct c from Customer c join c.customerEvents ce where ce.type = :type

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum