Re: Efficient qualifier for to-many relationships?
Re: Efficient qualifier for to-many relationships?
- Subject: Re: Efficient qualifier for to-many relationships?
- From: Ken Anderson <email@hidden>
- Date: Fri, 17 Feb 2006 19:24:10 -0500
Art,
Since Ondra's on 4.5, it's not deprecated (yet anyway). And I'm not
sure 4.5 handles that hint...
Ken
On Feb 17, 2006, at 6:43 PM, Art Isbell wrote:
On Feb 17, 2006, at 12:18 PM, Ken Anderson wrote:
In this case, I would use EOSQLQualifier. Something like:
exists (select 1 from reltable where t0.primaryKey =
reltable.foreignKey)
Using t0 assumes standard EOF SQL generation and the target table
should be the target of the query (not a relationship from
something else).
You can then mix the EOSQLQualifier in with other qualifiers to
further qualify the result if necessary.
But if you don't need to mix in other qualifiers and you don't
like using a deprecated class (EOSQLQualifier), you can send a
setHints() message to your fetch spec. The hints dictionary's key
would be EODatabaseContext.CustomQueryExpressionHintKey with your
custom SQL String being the dictionary's object.
Aloha,
Art
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40anderhome.com
This email sent to email@hidden
_______________________________________________
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