Hello, I have entities 'User' and 'Organisation'. Organisation has an optional relationship 'complianceOfficer' to User. What I'm trying to create is an EOQualifier on User that will match all the Compliance Officers. This raw SQL gets me the rows I want:
SELECT u.id FROM user u WHERE EXISTS (SELECT 1 FROM organisation o WHERE o.compliance_officer_id = u.id); I can't quite seem to get there with qualifiers—can anyone put me out of my misery? -- Paul Hoadley https://logicsquad.net/ https://www.linkedin.com/company/logic-squad/
_______________________________________________ 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]
