cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <and...@objectstyle.org>
Subject Re: Fetching distinct related objects
Date Wed, 23 Sep 2015 07:13:29 GMT
This is a bug.

> On Sep 22, 2015, at 5:36 PM, 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
View raw message