Return-Path: X-Original-To: apmail-cayenne-user-archive@www.apache.org Delivered-To: apmail-cayenne-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 7B71418D1A for ; Sun, 13 Sep 2015 19:02:45 +0000 (UTC) Received: (qmail 26153 invoked by uid 500); 13 Sep 2015 19:02:45 -0000 Delivered-To: apmail-cayenne-user-archive@cayenne.apache.org Received: (qmail 26122 invoked by uid 500); 13 Sep 2015 19:02:45 -0000 Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cayenne.apache.org Delivered-To: mailing list user@cayenne.apache.org Received: (qmail 26103 invoked by uid 99); 13 Sep 2015 19:02:45 -0000 Received: from Unknown (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 13 Sep 2015 19:02:45 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id A7E43C0041 for ; Sun, 13 Sep 2015 19:02:44 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.001 X-Spam-Level: * X-Spam-Status: No, score=1.001 tagged_above=-999 required=6.31 tests=[KAM_LAZY_DOMAIN_SECURITY=1, URIBL_BLOCKED=0.001] autolearn=disabled Received: from mx1-us-west.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id 2p28BxCZzWV9 for ; Sun, 13 Sep 2015 19:02:34 +0000 (UTC) Received: from smtp4.objectstyle.com (smtp4.objectstyle.com [23.253.156.183]) by mx1-us-west.apache.org (ASF Mail Server at mx1-us-west.apache.org) with ESMTP id 81B0620758 for ; Sun, 13 Sep 2015 19:02:34 +0000 (UTC) Received: from [10.61.39.42] (50-194-248-90-static.hfc.comcastbusiness.net [50.194.248.90]) by smtp4.objectstyle.com (Postfix) with ESMTPSA id 16A41CC35C for ; Sun, 13 Sep 2015 19:04:52 +0000 (UTC) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 8.2 \(2104\)) Subject: Re: Is there a canonical method of invoking aggregate functions From: Andrus Adamchik In-Reply-To: <6A1CB791-ADC8-4BED-8BDC-BE7C7D2CAEDE@karlmenn.is> Date: Sun, 13 Sep 2015 15:02:33 -0400 Content-Transfer-Encoding: quoted-printable Message-Id: <338C2B0A-8753-459A-B8E7-8F168516E819@objectstyle.org> References: <6A1CB791-ADC8-4BED-8BDC-BE7C7D2CAEDE@karlmenn.is> To: user@cayenne.apache.org X-Mailer: Apple Mail (2.2104) Hi Hugi, This was a big enough hole in the API, that I felt it needed fixing. I = just added support for the "path+" EJBQL syntax to Cayenne per = https://issues.apache.org/jira/browse/CAY-2027 . So you can build = Cayenne from master and use it right away.=20 Andrus > On Sep 12, 2015, at 9:03 AM, Hugi Thordarson wrote: >=20 > Hi all. >=20 > Since converting Expressions that use outer joins to EJBQL doesn=E2=80=99= t work in Cayenne, I find myself now using somewhat kludgy methods to = invoke aggregate methods (for example to retrieve the count of records = that an expression will yield). >=20 > Does anyone have a good solution or is there a standard way to do = this? >=20 > Cheers, > - hugi >=20 > // Hugi Thordarson > // http://www.loftfar.is/ > // s. 895-6688