• 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
Outer joins in EOFetchSpecification?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Outer joins in EOFetchSpecification?


  • Subject: Outer joins in EOFetchSpecification?
  • From: John Boynton <email@hidden>
  • Date: Wed, 10 Sep 2003 12:16:14 -0600

Hi all,

Is there a way to get an EOFetchSpecification to use an outer join for a relationship key instead of a simple join? I have a ChargeItem entity which can have an optional relationship "job" to a Job entity. I'd like to qualify on a user-entered date such that if the job is null, use the chargeDate; otherwise use the job's completion date. The qualifier string for this would be:

"(job = nil and chargeDate >= %@) or (job <> nil and job.completionDate >= %@)"

But this will generates a simple join clause like:

  FROM CHARGE_ITEM t0, JOB T1 WHERE t0.JOB_FK = T1.PRIMARY_KEY AND ...

instead of what I really want (using Oracle 9i syntax):

FROM CHARGE_ITEM t0 LEFT OUTER JOIN JOB T1 ON t0.JOB_FK = T1.PRIMARY_KEY WHERE ...

Is there a (simple) way to make the fetch spec. use the outer join instead?

Thanks,
John
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.

  • Follow-Ups:
    • Re: Outer joins in EOFetchSpecification?
      • From: Jonathan Rochkind <email@hidden>
  • Prev by Date: RE: modifying EOModel at run-time
  • Next by Date: Re: Outer joins in EOFetchSpecification?
  • Previous by thread: RE: modifying EOModel at run-time
  • Next by thread: Re: Outer joins in EOFetchSpecification?
  • Index(es):
    • Date
    • Thread