This one time, at band camp, [EMAIL PROTECTED] said:
> OQLQuery oql = _db.getOQLQuery( "SELECT p FROM Encounter p where p.unit
>= $1 order by p.bed.sortOrder");
>
>Class Encounter
>{
> long _id;
> long _bedId;
> long _patientID;
> String _unit;
> Patient _patient;
> Bed _bed;
>}
>
>Class Bed
>{
> long _id;
> int _sortOrder;
>}
>Class Patient
>{
> 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,
I'm trying to understand exactly what you want here. If you're
simply asking for an outer join option, to my knowledge, currently
there is no such thing. If you're asking if Castor can fetch
p.bed.sortOrder without a reference to the Bed object in the
Encounter object, this is not possible because the object graph
would be incomplete. Maybe I'm still confused on what you want.
--
perl -e 'print unpack("u30","<0G)U8V4\@4VYY9&5R\"F9E<G)E=\$\!F<FEI+F-O;0\`\`");'
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
