Creating Database Reports with EOF
Creating Database Reports with EOF
- Subject: Creating Database Reports with EOF
- From: "Sennikov, Dimitri" <email@hidden>
- Date: Fri, 14 Mar 2008 15:15:17 -0400
- Thread-topic: Creating Database Reports with EOF
I can't find any useful information on how to easily create database
reports. For example, I have a Projects entity. I want to create a report to
include # of projects created in each month of the past year.
With mysql I'd do the following:
select (select count(id) from projects
where datestarted >= '2008-01-01' and datestarted < '2008-02-01') as jan,
(select count(id) from projects where datestarted >= '2008-02-01' and datestarted
< '2008-03-01') as feb; etc…
How would I be able to do that in WO with
EOF? Is there an easier way than to get qualifiers for each month and create
new FetchSpecifications for each of the months? Wouldn’t this method
create too much overhead (ie 12 queries just for one report).
Thanks, any input is much appreciated,
Dmitri Sennikov
|
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden