title: CrudRepository Find by Custom join field filter
body: <p>I have below entity </p>
  
  <ol>
  <li>RequestObj</li>
  <li>AdditionalReqObj.</li>
  </ol>
  
  <p>Both entities are linked with <code>REQ_ID</code> column in table (<code>reqId</code> field). I am using <code>Spring data CrudRepository interface</code> for repository. </p>
  
  <p>Now I want to <code>findAll RequestObj entity</code> by <code>REQUEST.REQ_STATUS</code> which is open <strong>&amp;</strong> linked Additional request should also be filter by <code>ADDL_REQUEST.ADD_REQ_STATUS</code></p>
  
  <pre><code>@Entity
  @Table(name = "REQUEST")
  public class RequestObj implements Serializable {
  
      @Id
      @Column(name = "REQ_ID")
      private long reqId;
  
      @Column(name = "REQ_NM")
      private String reqUserNm;
  
      @Column(name = "REQ_EMAIL")
      private String reqUserEmail;
  
      @Column(name = "REQ_ID")
      private String reqComments;
  
      @Column(name = "REQ_STATUS")
      private String reqStatus;
  
      @OneToMany(mappedBy = "request", fetch = FetchType.EAGER, cascade = CascadeType.ALL)
      private List&lt;AdditionalReqObj&gt; requestDtls;
  
      ---getter setter----
  }
  
  @Entity
  @Table(name = "ADDL_REQUEST")
  public class AdditionalReqObj implements Serializable {
      private static final long serialVersionUID = 1L;
  
      @Id
      @Column(name = "AdD_REQ_ID")
      private long addReqId;
  
      @Column(name = "ROLE_NM")
      private String add_req_comment;
  
      @ManyToOne
      @JoinColumn(name = "REQ_ID")
      private RequestObj request;
  
      @Column(name = "ADD_REQ_STATUS")
      private String addReqStatus;
  
      ---getter setter----
  }
  </code></pre>