cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John Huss <johnth...@gmail.com>
Subject Re: Fetching distinct related objects
Date Tue, 22 Sep 2015 15:29:29 GMT
selectQuery.setDistinct(true);

On Tue, Sep 22, 2015 at 9:37 AM Hugi Thordarson <hugi@karlmenn.is> wrote:

> Hi all,
>
> I’m trying to retrieve a list of distinct related objects. If I execute an
> EJBQL-query that looks like this…
>
> "select distinct receipt.shop from Receipt receipt”
>
> …where “shop” is a relationship on the “Receipt”-entity, I get an
> exception that looks like this:
>
> https://gist.github.com/hugith/c3f48c4576e6a55383b3
>
> Doing the same fetch without the distinct keyword works fine (returns a
> list of Shop objects). Also, performing a distinct fetch on attributes of
> “Shop” works fine, like so:
>
> "select distinct receipt.shop.name from Receipt receipt”
>
> Is this a bug or am I going around this the wrong way? How would you go
> about constructing a fetch for distinct related objects?
>
> Cheers,
> - hugi
>
> // Hugi Thordarson
> // http://www.loftfar.is/
> // s. 895-6688

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message