Doesn't setDistinct always work with the entire row? I’m attempting to fetch just the distinct values of certain relationships. I haven’t found an API for that in Cayenne, that’s why I’m using EJBQL.
Then again, I might be on the wrong track… Thanks, - hugi > On 22. sep. 2015, at 15:29, John Huss <johnth...@gmail.com> wrote: > > selectQuery.setDistinct(true); > > On Tue, Sep 22, 2015 at 9:37 AM Hugi Thordarson <h...@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