title: Spring CrudRepository - 'not equals' condition for child table(which is as List)
body: <p>I've two entity with @OneToMany relationship</p>
  
  <p>First Entity</p>
  
  <pre><code>    @Entity
      @Table(name = SchemaConstant.RESCHEDULE_TABLE_NAME)
      public class RescheduleRequestEntity extends BaseEntity {
        @Id
        @GeneratedValue(strategy = GenerationType.AUTO, generator = "RESCHEDULE_ID_GEN")
        @SequenceGenerator(
            name = "RESCHEDULE_ID_GEN",
            allocationSize = 1,
            sequenceName = SchemaConstant.RESCHEDULE_SEQUENCE_NAME)
        private Long id;
  
        private String adviseNo;
        private LocalDate adviseDate;
        private Long customerId;
  
        @Enumerated(value = EnumType.STRING)
        private AdviceStatus status;
  
        @OneToMany(mappedBy = "reschedule", fetch = FetchType.LAZY)
        private List&lt;RescheduleDetailEntity&gt; accountDetails;
  
      }
  </code></pre>
  
  <p>Second Entity</p>
  
  <pre><code>    @Entity
      @Table(name = "RESCHEDULE_DETAILS")
      public class RescheduleDetailEntity extends BaseEntity {
  
        @Id
        @GeneratedValue(strategy = GenerationType.AUTO, generator = "RESCHEDULE_DETAILS_ID_GEN")
        @SequenceGenerator(
            name = "RESCHEDULE_DETAILS_ID_GEN",
            allocationSize = 1,
            sequenceName = "S_RESCHEDULE_DETAILS")
        private Long id;
  
        @OneToOne(fetch = FetchType.LAZY)
        @JoinColumn(name = "ACCOUNT_ID", nullable = false)
        private AccountEntity account;
  
        @Enumerated(value = EnumType.STRING)
        private AdviceStatus status;
  
        @Enumerated(value = EnumType.STRING)
        private TenureType tenureType;
  
        private Integer tenure;
  
        @ManyToOne
        @JoinColumn(name = "ADVISE_ID")
        private RescheduleDetailEntity reschedule;
      }
  </code></pre>
  
  <p>AND Enum</p>
  
  <pre><code>    public enum AdviceStatus {
        OPEN,
        ACTIVE,
        CLOSE
      }
  </code></pre>
  
  <p>I want to fetch data with condition Like</p>
  
  <pre><code>    SELECT *
        FROM RESCHEDULEREQUESTENTITY R, RESCHEDULEDETAILENTITY D
       WHERE R.ID = :PID
         AND D.ADVISEID = R.ID
         AND D.STATUS &lt;&gt; "CLOSE"
  </code></pre>
  
  <p>"Data fetch from RescheduleRequestEntity with data from RescheduleDetailEntity where RescheduleDetailEntity.status is not equal "CLOSE" where "Status" is Enum type".</p>
  
  <p>I create a JPA Repository class like following for fetch data </p>
  
  <pre><code>    @Repository
      public interface RescheduleRequestRepository
          extends JpaRepository&lt;RescheduleRequestEntity, Long&gt;, JpaSpecificationExecutor {
  
        Optional&lt;RescheduleRequestEntity&gt; findByAdviseNo(String adviceNo);
  
        Optional&lt;RescheduleDetailEntity&gt; findByIdAndAccountDetails_StatusNot(
            Long adviceId, AdviceStatus status);
      }
  </code></pre>
  
  <p>but it's not fetch data with my desired condition,it's not ignore data which have Status "CLOSE"</p>