title: Spring Data JPA Find By List of Objects
body: <p>Given the following schema,</p>
  <pre><code>public class Product {
      @Id
      @GeneratedValue(strategy = GenerationType.AUTO)
      private Long id;
  
      private String productName;
  
      private String category; 
  
      private String vendorName;
  
  // Constructor, getters and setters
  }
  </code></pre>
  <p>I would like to find all <code>products</code> that equals to any pair of <code>category</code> and <code>vendorName</code>
  I have created a class for this</p>
  <pre><code>public class FilterRequest {
      private String vendorName;
      private String category;
  
  // Constructors, getters and setters
  }
  </code></pre>
  <p>Ideally the repo should have the following signature,</p>
  <pre><code>@Query(---QUERY---)
  List&lt;Product&gt; findAllByFilterRequestList(List&lt;FilterRequest&gt; filterRequests);
  </code></pre>
  <p>Any idea how I should approach this? I am thinking of doing this one by one, but it will affect the performance.</p>