[ https://issues.jboss.org/browse/ARTIF-202?page=com.atlassian.jira.plugin.... ] Brett Meyer commented on ARTIF-202: ----------------------------------- Thanks a million to [~rhauch] for pointing this out: Another idea is to break the relationships into groups of children. So under an artifact you'd have a child named `elements` and under that all of the relationship nodes with a type of `element`. Then finding all artifacts that have no 'element' relationship becomes something like: {code} SELECT artifact.* FROM [sramp:baseArtifactType] AS artifact OUTER JOIN [sramp:relationshipContainer] AS relationshipContainer ON ISCHILDNODE(relationshipContainer,artifact) WHERE artifact.[sramp:artifactType] = 'Part' AND (NAME(relationshipContainer) != 'entity' OR CHILDCOUNT(relationshipContainer) = 0) {code} The query needs an OUTER JOIN so that it also returns all artifacts that have no child nodes (which means it doesn't have an 'entity' relationship. -- This message was sent by Atlassian JIRA (v6.3.11#6341)