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 protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
