[castor-dev] outer joins & order by on a field within a nest class. Field may be null

[Kevin . Lanaghan]

I'm having a problem with an order by in the query below when bed is not
defined.

 OQLQuery oql = _db.getOQLQuery( "SELECT p FROM Encounter p where p.unit
= $1 order by p.bed.sortOrder");

Class Encounter
{
  String _unit;
  Patient  _patient;
   Bed   _bed;
}

Class Bed
{
   long  _id;
   int _sortOrder;
}

This query does work when _bed is defined.  However when its null the that
record is not retrieved.  Does Castor have the equivalent of an outer join
so that all encounters belonging/occurring in a given unit are retrieved.


Kevin

----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
        unsubscribe castor-dev