On May 30, 2006, at 10:25, Øyvind Harboe wrote:
If I manually modify the generated query from the orExp() case to use
a LEFT OUTER JOIN instead of INNER JOIN, I get the expected
result.
AFAIK Cayenne does not support outer join yet. Google got me to this
one:
http://www.objectstyle.org/cayenne/lists/cayenne-user/2006/04/0170.html
Before this is solved by cayenne, you will have to implement this in
your app. You can create two queries and do a union in java or create
a custom query:
http://www.objectstyle.org/confluence/display/CAYDOC/Customizing+Queries
- Tore.
