Re: ERXExistsQualifier
Re: ERXExistsQualifier
- Subject: Re: ERXExistsQualifier
- From: Paul Hoadley <email@hidden>
- Date: Fri, 24 Apr 2015 09:16:40 +0930
I haven't got anything significant to say about Thomas's original post, but just to add a couple of data points:
On 24 Apr 2015, at 5:36 am, Fabian Peters <email@hidden> wrote:
AFAIK, it should work for multiple tables, except if any of them use compound primary keys.
This seems to be the received wisdom, but it's just not true in the general case. I have used ERXExistsQualifier on an entity with a compound PK just fine. What you _can't_ do (for obvious reasons) is force it to generate SQL with an IN clause. Whether there are edge cases where you can't combine ERXExistsQualifier, compound PKs, and SQL with an EXISTS clause, I don't know.
You may want to try the ExistsInRelationshipQualifier from the Houdah frameworks, which does handle flattened many-to-many relations.
I certainly can confirm that flattened relationships break ERXExistsQualifier every time.
|
_______________________________________________
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