Re: reportQuery and functions in query

2007-12-14 Thread Joose Vettenranta
To make this question simpler, how to do reportquery where: queryArguments[0] ="id"; queryArguments[1] ="sum(foo.bar * foo.quux *)"; Thanks, Joose Joose Vettenranta kirjoitti 23.11.2007 kello 14.59: Hi, I have query that has like SELECT sum(foo) FROM bar; and that works ok. Problem comes

reportQuery and functions in query

2007-11-23 Thread Joose Vettenranta
Hi, I have query that has like SELECT sum(foo) FROM bar; and that works ok. Problem comes with following syntax: SELECT sum(foo * quux) FROM bar; Code goes something like this: query=new org.apache.ojb.broker.query.ReportQueryByCriteria(ibizobj.getClass(), criteria); queryArguments[0]="