Re: Efficient qualifier for to-many relationships?
Re: Efficient qualifier for to-many relationships?
- Subject: Re: Efficient qualifier for to-many relationships?
- From: Art Isbell <email@hidden>
- Date: Fri, 17 Feb 2006 13:43:30 -1000
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:
This email sent to email@hidden