"fetch all As that are either assigned to a given B or not assigned at all". That sounds like a right outer join. You can set the join semantics on the relationship in EOModeler. You probably don't want that for the main relationship, but I think you can define one that is not a class property and use that for the fetch.
Otherwise, I think you need a UNION. I don't recall that Wonder generates UNIONs, but there is a lot in there... There might be some other combination of qualifiers that work, checking the generated SQL is the best way to get a view into why it is not working. Chuck From: <[email protected]<mailto:[email protected]>> on behalf of Markus Ruggiero <[email protected]<mailto:[email protected]>> Date: Monday, October 5, 2015 at 5:28 AM To: WebObjects-Dev Mailing List List <[email protected]<mailto:[email protected]>> Subject: EOQualifier for an optional to many relationship I have an optional many-2-many relationship between entities A and B. EntityModeler creates a join table with nothing modelled but the logical m:n relationships. Now I need a qualifier to fetch all As that are either assigned to a given B or not assigned at all. Following part works (finding all As assigned to a given B): A.TO_MANY_B_ERXKEY.eq(myBObject) Trying to find all As that have NO relationship to any B either finds nothing A.TO_MANY_B_ERXKEY.isNull() or results in a NullPointerException A.TO_MANY_B_ERXKEY.isEmptyRelationship() What am I missing here? In the end I want to simply join the two partial qualifiers by .or() Thanks ---markus---
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
