• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Creating Database Reports with EOF
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

  • Follow-Ups:
    • Re: Creating Database Reports with EOF
      • From: Petite Abeille <email@hidden>
References: 
 >New Tool: Click to Open (From: Chuck Hill <email@hidden>)

  • Prev by Date: DynEd's Looking for a MySQL Administrator w/WebObjects awareness
  • Next by Date: Re: Creating Database Reports with EOF
  • Previous by thread: New Tool: Click to Open
  • Next by thread: Re: Creating Database Reports with EOF
  • Index(es):
    • Date
    • Thread