Query to filter collection [message #809095] |
Tue, 28 February 2012 08:29  |
Eclipse User |
|
|
|
Hi,
I would appreciate any advice with this problem:
Let's assume I have two entities: Order and Item (one order can contain number of items)
@Entity
public class Order
@Id
@Column(name = "order_id")
private Integer orderId;
@Column(name = "order_date")
@Temporal(TemporalType.DATE)
private Date orderDate
@OneToMany(mappedBy = "order", cascade = CascadeType.ALL)
private List<Item> itemList
....
@Entity
public class Item
@Id
@Column(name = "item_id")
private Integer itemId;
@Column(name="item_text")
private String itemText;
@Column(name="item_value")
private Integer itemValue;
@ManyToOne(cascade = CascadeType.ALL)
@JoinColumn(name = "order_id", referencedColumnName = "order_id")
private Order order
....
I want to select orders which contains items where item value=100. But I want to Order.itemList to be filled only with items of value 100.
Is this possible (EclipseLink 1.1.4, Tomcat 6)
Thanks
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.05166 seconds