Hibernate Community • View topic - Filtering on max value in sub query

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Filtering on max value in sub query

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

martijnhiemstra

Post subject: Filtering on max value in sub query

Posted: Fri Oct 30, 2015 10:08 am

Newbie

Joined: Fri Oct 30, 2015 9:56 am
Posts: 1

Hi all,

I am writing a Tv guide and I have the following object structure. I have a Program class that has a list of episodes and each episode has a list of broadcasts.

Now I want to display a list of episodes beloning to a certain program of which the first broadcast is now later than 2 weeks ago. So I want to get all the episodes that have been aired for the first time in the last 2 weeks.

I have tried using sub queries however no luck getting the right results. I have found the right SQL command with the following:

Code:

select id, (SELECT MIN(startDate) AS minStartDate FROM broadcasts where episode_id=e.id) from episodes e where e.programId=?

This generates a list of episodes of a certain program and the first broadcast airtime for that episode. How can I convert this into a query (HQL or preferably (Detached)Criteria)?

Thanks in advanced,
Martijn

Top

Page 1 of 1

[ 1 post ]

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