Hi everybody,
following question:
I have a persitent class called TRACK
TRACK includes an Attribute called "ContentSet" (many to one), see TRACK:
Code:
..
<class name="com.nuromobile.accounting.DomainObjects.Track"
table="track">
..
<many-to-one name="contentSet"></many-to-one>
..
A ContentSet has a List of ContentItems (many to many):
Code:
..
<class name="com.nuromobile.accounting.DomainObjects.ContentSet"
table="content_set">
..
<list name="Items" table="sets_items">
<key column="set_id" />
<list-index column="ind" />
<many-to-many column="item_id"
class="com.nuromobile.accounting.DomainObjects.ContentItem" />
</list>
Code:
<class name="com.nuromobile.accounting.DomainObjects.ContentItem" table="content_item">
..
<many-to-one name="contentProducer"></many-to-one>
..
Each ContentItem has a Content-Producer, the one who created the Item(many-to-one).
My problem is that i dont know how to select the following:
"Give me all Items of ContentSets, which are in the Track-Table and which have the Content-Producer X"
I thought about it a long time but i dont know how to do it?
I am thankfulkl for any advice.
[/code]