Search with aggregate functions

sarbogast · **Posted:** Wed Jul 18, 2012 8:38 am

I have an Item entity like this:

Code:

@Entity
public class Item {
    @ToMany
    List<Comment> comments;
}

And I would like to search all items that have between 5 and 10 comments, or sort items that correspond to a keyword by decreasing number of comments.
Is it possible with Hibernate Search. How should I annotate and index my Item class? What should the query look like?

hardy.ferentschik · **Posted:** Mon Jul 23, 2012 9:46 am

Hi,

that is unfortunately not possible atm.
One way of achieving it indirectly, however, would be to index the collection size separately with a custom field/class bridge. Then you could use this field for your search.

--Hardy