**Requirement**

I have a simple OneToMany Relationship between two entities. I want to use JPA property expression to find Parent Entity with a condition which matches all children entities. 

**Parent**

```
@Entity
public class PcSigningStatus {
    @OneToMany(cascade = CascadeType.ALL, mappedBy = "signingStatus")
    private List<PcSigningProcessEvent> signingProcessEvents = new ArrayList<>();

```

**Child**

```
@Entity
public class PcSigningProcessEvent {
    @Enumerated(EnumType.STRING)
    private ProcessEventType phase;

    @ManyToOne
    @JoinColumn(name = "SIGNING_STATUS_ID")
    private PcSigningStatus signingStatus;
}

```

**Parent Repository**

```
public interface SigningStatusRepo extends CrudRepository<PcSigningStatus, Long> {
    PcSigningStatus[] findBySigningProcessEvents_PhaseNot(ProcessEventType phase);
}

```

**Issue**

Suppose I only have 1 parent entity in database with 2 child entities containing different value of **phase**. The above query returns the same parent multiple times depending on the number of children it does not match the value of **phase** in. I need help in finding a way that Parent entity is returned only if the **phase** is not present in all the children entities