OQL to get distinct members

0
Hi,   Can some one help me in writing OQL for following use case. Need to get distinct members from Contribution table where status association is empty. Here association between members and Contribution is one to many and between Status and contribution is one to one.   TIA
asked
1 answers
0

Maybe share a screenshot from this part of your domain model to clarify. But I'd imagine something like this:

SELECT DISTINCT c/attributeName

FROM Module.Contribution c

LEFT OUTER JOIN c/Module.Contribution_Status/Module.Status s

WHERE s/id = null

 

So to check for empty associations, use left outer join and a WHERE contraint on id = null.

answered