RE: Outer joins in EOFetchSpecification?
RE: Outer joins in EOFetchSpecification?
- Subject: RE: Outer joins in EOFetchSpecification?
- From: "Albert Jagnow" <email@hidden>
- Date: Wed, 10 Sep 2003 13:55:25 -0500
- Priority: normal
- Thread-topic: Outer joins in EOFetchSpecification?
I am not very much an expert on SQL, but in EOModeler in the
relationship inspector you can select inner, full outer, left outer, or
right outer for the type of join to use. Will this do what you want?
--Albert
-----Original Message-----
From: John Boynton [mailto:email@hidden]
Sent: Wednesday, September 10, 2003 1:16 PM
To: Apple WebObjects Dev
Subject: Outer joins in EOFetchSpecification?
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.
This e-mail (including any attachments) is covered by the Electronic
Communications Privacy Act, 18 USC. 2510-2521. It is confidential and
may be legally privileged. If you are not the intended recipient, you
are hereby notified that any retention, dissemination, distribution, or
copying of this communication is strictly prohibited. Please reply to
the sender that you have received the message in error, and then delete
it. Thank you.
_______________________________________________
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.