Hello Paul, if User had a to-many relationship to Organization (the inverse of complianceOfficer), you could use:
User.ORGANISATIONS.containsAnyObjectSatisfying(new ERXTrueQualifier()) Best regards, Stefan -- Mit freundlichen Grüßen Stefan Gärtner /// IT/Software-Entwicklung /// NUREG GmbH /// Dorfäckerstraße 31 | 90427 Nürnberg | Germany Tel.: +49-911-32002-183 | Fax: +49-911-32002-299 Nürnberg HRB 22653 | USt.ID DE 814 685 653 Geschäftsführer: Michael Schmidt, Stefan Boas www.nureg.de<http://www.nureg.de> Von: Paul Hoadley via Webobjects-dev <[email protected]> Antworten an: Paul Hoadley <[email protected]> Datum: Dienstag, 7. Oktober 2025 um 06:38 An: OCsite via Webobjects-dev <[email protected]> Betreff: Exists qualifier 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]
