left join fetch. How do you order the collection fetched?

JohnRock · **Posted:** Thu Mar 26, 2009 2:55 am

I am using a left join fetch in the following JPQL:

Code:

select distinct q from Question q 
          left join fetch q.responses
         where q.user.username = :uName 
          and q.type = :qType
         order by q.created desc

Is there a way that I can also sort the collection (q.responses) in this query?

I.E. Imagine the collection contains RESPONSE entities that have a date field called createDate. I would like to do an order by response.createDate.

littypreethkr · **Posted:** Thu Mar 26, 2009 3:45 am

There is an order-by field for the <set>, <map> etc mappings. You can use that. For eg:

Code:

      <set name="responses" table="responses" cascade="all-delete-orphan" order-by="createDate">
         <key column="QUE_ID" />
         <one-to-many class="Response" />
      </set>

JohnRock · **Posted:** Thu Mar 26, 2009 4:22 pm

Thank you. That was exactly what I was looking for. I ended up using the Annotation:

@OrderBy("created DESC")

Regards,
John