.
Cheers,
Tony
-Original Message-
From: Andrus Adamchik [mailto:and...@objectstyle.org]
Sent: Monday, 13 April 2009 10:19 p.m.
To: user@cayenne.apache.org
Subject: Re: General queries
> However, I wondered if it could cope with the first subselect and so
> ended up with this EJ
On Apr 9, 2009, at 2:24 AM, Weddle, Anthony wrote:
EJBQL doesn't support subselects in the select clause or have
something
equivalent to the NVL function, so we'd have to do things differently.
Correct.
However, I wondered if it could cope with the first subselect and so
ended up with this
and (iosbu.toIosb.useByDt is null
or iosbu.toIosb.useByDt > CURRENT_DATE)
group by iosbu.toIosb.toIos.id
I'm getting there!
Cheers,
Tony
-Original Message-----
From: Andrus Adamchik [mailto:and...@objectstyle.org]
Sent: Wednesday, 8 April 2009 5:46 p.m.
To: user@cay
On Apr 8, 2009, at 10:27 PM, Weddle, Anthony wrote:
One of the main problems I'm having is that there is so little
documentation, books and articles about Cayenne. Is there a fairly
comprehensive list of publications (not necessarily books) on Cayenne?
Unfortunately no. Cayenne developer comm
nne. Is there a fairly
comprehensive list of publications (not necessarily books) on Cayenne?
Tony
-Original Message-
From: Andrus Adamchik [mailto:and...@objectstyle.org]
Sent: Wednesday, 8 April 2009 5:46 p.m.
To: user@cayenne.apache.org
Subject: Re: General queries
Cayenne 3.0
books) on Cayenne?
Tony
-Original Message-
From: Andrus Adamchik [mailto:and...@objectstyle.org]
Sent: Wednesday, 8 April 2009 5:46 p.m.
To: user@cayenne.apache.org
Subject: Re: General queries
Cayenne 3.0 includes support for EJBQLQuery which seem like you what
you need here:
http
Hi Anthony,
I think the feature you are after in Cayenne is Named Queries. In the
CayenneModeler click on the "Create Query" icon, then in dialog
"Select New Query Type" select the "Raw Query" option and then
"Create" button.
This will take you to a screen where you can define the query name and
Cayenne 3.0 includes support for EJBQLQuery which seem like you what
you need here:
http://cayenne.apache.org/doc/ejbqlquery.html
We are following the JPA syntax per JSR-220 (http://jcp.org/aboutJava/communityprocess/final/jsr220/index.html
). At does support aggregates, separate columns, s
We're looking at moving from Hibernate to Cayenne but I'm having trouble
finding out how to perform queries that return arbitrary data, maybe
they are sometimes called report queries. Something like Hibernate's HQL
queries that can return arbitrary data (including aggregate functions or
simply a bu
