Re: Efficient qualifier for to-many relationships?
Re: Efficient qualifier for to-many relationships?
- Subject: Re: Efficient qualifier for to-many relationships?
- From: Arturo Pérez <email@hidden>
- Date: Fri, 17 Feb 2006 23:05:37 -0500
IIRC, we used that hint under 4.5.
-arturo
On Feb 17, 2006, at 7:24 PM, Ken Anderson wrote:
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:
email@hidden
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:
email@hidden
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