Here is my problem:

1.) I have three tables. The middle one is an association table with extra attributes on the association. For that reason, I have a class [BirtReportCriteriaImpl.java] that holds the attributes contained on the middle association table.

2.) The setup is:

BIRT_REPORT_LIST 1:M BIRT_REPORT_LIST_CRITERIA M:1 BIRT_REPORT_CRITERIA

3.) The middle table has the extra attributes I'm mapping. The most important one for me is the CRITERIA_ORDER field, which should tell me the order to return the BirtReportCriteria (the assocation) objects ORDERED-BY the CRITERIA_ORDER

4.) My question is: How do I tell it to order by CRITERIA_ORDER (which only exists on the association table?)

Thank you,
Ty



Hibernate version:
3.1

Mapping documents:












Java Classes To Support The Above




BirtCriteriaImpl.java



BirtReportCriteriaImpl.java

The reportCriteriaList bag in BirtReportImpl can be ordered using either the order-by attribute (to order when doing the select) or the sort attribute (to sort in memory after fetching the rows from the BIRT_REPORT_LIST_CRITERIA table).

Tenwit,
Thank you kindly for the reply. Can you tell me how to award points? I don't see how to do that.

thank you,
Ty

Click on the "yes" at the bottom of the post that helped.