Hi Jacob,
Every relation is defined. But in the report queries I can only specify
the columns in String[] {}, I wish I could specify the queries as well
and pass it in Object[] {}, just like it is done for Criteria methods.
F.e :
Query qB = QueryFactory.newReportQuery(B.class); // SELECT COUNT(*) FROM
B
Query qC = QueryFactory.newReportQuery(C.class); // SELECT AVG(C.FF)
FROM C
Query qD = QueryFactory.newReportQuery(D.class); // SELECT MAX(D.FFF)
FROM D
ReportQueryByCriteria q = QueryFactory.newReportQuery(A.class);
q.setAttributes(
new Object[] {
"F",
qB,
qC,
qD
}
)
Is this functionality is planned in the roadmap of OJB?
-Sergey
-----Original Message-----
From: Jakob Braeuchi [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 31, 2006 3:53 PM
To: OJB Users List
Subject: Re: solution for subqueries returning values
hi sergey,
this looks like a report query to me. do you have relationships defined
between A, B, C, D ?
jakob
Manukyan, Sergey schrieb:
> Folks,
>
> Could you please advice an OJB solution for this SQL query:
>
> SELECT
> A.F,
> (SELECT COUNT(*) FROM B INNER JOIN A ON A.F = B.F),
> (SELECT AVG(C.FF) FROM C INNER JOIN A ON A.F = C.F),
> (SELECT MAX(D.FFF) FROM D INNER JOIN A ON A.F = D.F)
> FROM
>
> A
>
>
> The OJB subqueries mechanism doesn't work in this case or... am I
> missing anything?
>
>
> -Sergey
>
>
>
>
> **********************
> ** LEGAL DISCLAIMER **
> **********************
>
> This E-mail message and any attachments may contain
>
> legally privileged, confidential or proprietary
>
> information. If you are not the intended recipient(s),
> or the employee or agent responsible for delivery of
>
> this message to the intended recipient(s), you are
>
> hereby notified that any dissemination, distribution
>
> or copying of this E-mail message is strictly
>
> prohibited. If you have received this message in
>
> error, please immediately notify the sender and
>
> delete this E-mail message from your computer.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
