Hi Mattieu, Thank you for reply but this approach doesn't work, I wasn't descriptive enough in my mail but that is exactly what I tried to do,
Regards, Sergey -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, September 01, 2005 5:13 AM To: OJB Users List Subject: Réf. : complex group, or subquery, or ... ? Hi, you need to define relationship between T1 / T2 and T1/T3 then use the attribute name for the field (as defined in your repository_user.xml). For instance : T1: class Foo, attribute id <--> F1, with a relationship fooBar1 to the class Bar1 and with a relationship fooBar2 to the class Bar2 T2: class Bar1, T3: class Bar2, your attributes for the reportQuery are : String [] attributes ={"id","count(fooBar1)","count(fooBar2)"}; Cordialement Matthieu PATOU DINQ/DSIN/SIDM/VNVO/VOIN Téléphone 01 30 19 17 91 (29 17 91) "Manukyan, Sergey" <[EMAIL PROTECTED] Pour com> [email protected] cc 30/08/2005 18:33 Objet complex group, or subquery, or ... Veuillez ? répondre à OJB Users List <[EMAIL PROTECTED] che.org> Folks, I have three tables: TABLE (FIELDS,...) : {(DATA),...} ---------------------------------------------- T1 (F1) : {(1)} T2 (F1,F2) : {(1,1),(1,2)} T3 (F1,F3) : {(1,10),(1,20),(1,30)} Need to make a report query to select : F1, count(T2), count(T3), So in given example need a result to be: 1, 2 , 3 I attempted to do it in the flowing way but it evidently didn't' work: ReportQueryByCriteria qry = QueryFactory.newReportQuery(T1.class, null); qry.setColumns(new String[] { "F1", "count(T2.*)", "count(T3.*)" } qry.addGroupBy(new String[] { "F1" } Can I use subqueries to do it? If so can anyone please give me a hint how I can do it, or point me in some other way I can do it with OJB, Thank you in advance, 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]
