Hypothetically if I was creating a forum application that had many Topics with each Topic having possibly thousands of Posts. Say in the view that shows available Topics I wanted to give the date of the most recent Post (and other details of a Post such as the name of the poster, etc) under that topic. Does anyone have any examples or ideas on how to do this? Assuming that there is a one-to-many relationship from Topics to posts.

Should I try to add a property to Topic that stores the most recent Post? Maybe using a column formula to find it?

I haven't been able to find any examples of someone solving a similar problem. Any direction would be much appreciated.

Thanks.

I would use HQL to retrieve the posts.

Cheers,
Radu

I believe I understand how to get the Posts themselves to show in a list, but how do I, in the list of topics, find the most recent one.

So a view like this


Is their an HQL way to join the Topics with the Posts finding the most recent Post only?

Try giving something like this a shot ...

This works perfectly and is just what I wanted help understanding. I think I now have a much better grasp of HQL given that example.

Thank you for your time.