Hibernate Community • View topic - Sorting a list of items base on the size of the item's set

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Sorting a list of items base on the size of the item's set

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

newreaders

Post subject: Sorting a list of items base on the size of the item's set

Posted: Wed Feb 02, 2005 7:45 pm

Beginner

Joined: Wed Sep 15, 2004 3:14 am
Posts: 35

Hi

How can I sort a list of items base on the size of the item's set? e.g.

Code:

public class User{
   private Set posts;

   public getPosts() {
        return posts;
   }

    public setPosts(Set posts) {
        this.posts = posts;
    }
}

I use the following HSQL, but it doesn't work:

Code:

from User u order by u.posts.size sort by asc

Can someone please help me?

Top

newreaders

Post subject:

Posted: Wed Feb 09, 2005 5:39 am

Beginner

Joined: Wed Sep 15, 2004 3:14 am
Posts: 35

Does Hibernate support this sort of thing?

It amazes me that no one has faced this problem.

Top

basterbrugge

Post subject:

Posted: Wed Feb 09, 2005 5:42 am

Newbie

Joined: Wed Sep 01, 2004 9:04 am
Posts: 18
Location: Enschede, Netherlands

I think HQL does, check the reference documentation

http://www.hibernate.org/hib_docs/reference/en/html/queryhql.html#queryhql-ordering

Top

Page 1 of 1

[ 3 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