How to filter max time record using session.filter?

Yashnoo · **Joined:** Wed Dec 17, 2003 4:24 am **Posts:** 188

Hi everyone:

I have a article Set ,and I want to get the last post article from this articles. I use the following code:

Code:

Article lastPost=(Article)session.filter(article.getArticleSet(),"this.articleTime=max(articleTime)");

But it can't work. If session.filter can do this, how to write it? Thks[/code]

Yashnoo · **Joined:** Wed Dec 17, 2003 4:24 am **Posts:** 188

Now I do it use this method:

Code:

String userid=user.getUserid();
List articles=session.find("from Article a ,User u where a.user.userid="+userid+" order by articleTime asc" ); <--order by time

Article article=(Article)articles.get(0); <--- order by time will get last post

But it is not convinent. What 's the best method to do this if I use session Filter? Thks[/code]