Re: orExp resulting in *fewer* results

From: Tore Halset (halse..vv.ntnu.no)
Date: Tue May 30 2006 - 09:10:02 EDT

  • Next message: Øyvind Harboe: "Re: orExp resulting in *fewer* results"

    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.

    This archive was generated by hypermail 2.0.0 : Tue May 30 2006 - 09:10:37 EDT