Is it possible to filter by a count of a List(Set..'bag') property?

[bar...@gmail.com]

My Entity is similar to that:

@Entity
public class Item implements Serializable {
 @Id
 private Long id;

 @OneToMany(cascade = CascadeType.ALL, fetch = FetchType.EAGER)
 private List<Sample> samples;
}

and i was wondering what is the best way (simple, clean, quick fetch, single query) to filter for the Items with the greater than 30 samples.size().

To make it clearer - we need to get only the Items which their samples collection size is bigger than 30.

Appreciate any assistance :)

[bar...@gmail.com]

Sorry.. i think i just found the solution it here:

https://groups.google.com/d/msg/java-generic-dao/0QnZi3-k9A4/ODFzmh3T5tcJ

Checking right now :)

[bar...@gmail.com]

Confirmed - this is working:

 Search search = new Search(Item.class);
 search.addFilterCustom("?1 < (select count(*) from {samples})", 29l);
 List<Item> items = this.search(search);

Thanks! :)

On Tuesday, February 10, 2015 at 10:27:28 AM UTC+2, bar...@gmail.com wrote: