FAQ
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 wrote:

selectQuery.setDistinct(true);
On Tue, Sep 22, 2015 at 9:37 AM Hugi Thordarson 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

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 3 of 9 | next ›
Discussion Overview
groupuser @
categoriescayenne
postedSep 22, '15 at 2:37p
activeSep 23, '15 at 8:02a
posts9
users3
websitecayenne.apache.org

People

Translate

site design / logo © 2021 Grokbase