Edit Question - KnowledgeHub

Title Body

I have an Class with a unidirectional one to many relationship as follows: public class Order { @OneToMany(cascade = CascadeType.ALL) @JoinTable(name="order_item", joinColumns={@JoinColumn(name="order_id")}, inverseJoinColumns={@JoinColumn(name="item_id")}) public Set<Item> getItems() { return items; } } Normally getting the contents of this order is straightforward: List<Item> items = order.getItems(); But for whatever reason I might want to filter my results in some way and retrieve only part of a collection of items such as all items more than a certain price, below a certain stock etc in the fastest way possible (Not returning then all then filtering afterwards). To do this I would run a HQL query to retrieve the items for a particular order and add some more stuff into my where clause or onto my query object. Intuitively I would want this behaviour (Which is completely wrong): SELECT jointable.ITEM from order_item as jointable inner join jointable.order where order = :order But of course this is wrong as HQL works in terms of mapped entities, so I cannot use the join table in the query. So what is the correct way to do this? Edit: I have found the answer to this question, I want the following Query: Select o.items from Order o where o = ? This allows me to fetch the collection of items for an order, without having to use a bidirectional relationship. I am now however confused on the second stage of this question, which is how to filter the results of this collection, the most simple example being: Select o.items from Order o where o = ? order by o.items.somenumberfield asc Which returns illegal attempt to dereference collection, so how would I filter my items? Edit: The ticket s

Tags (comma-separated) Cancel