Outer joins in EOFetchSpecification?
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.