0 Replies Latest reply on May 12, 2004 1:39 AM by Sebastiaan Kortleven

    order by on cmr fields attribute

    Sebastiaan Kortleven Newbie

      Hi there,

      I'm running a jboss-ql query and I would like to sort the results on one of the cmr fields attributes like this:

      SELECT OBJECT(rpp)
      FROM ReferenceProductPrice
      WHERE rpp.pricelistRelease.row_id = ?1
      ORDER BY rpp.product.code ASC

      But it doesn't seem to work (no error though).. Does JBoss support this?

      Thanks!