title: SQL IN Operator equivalent in Elastic Search with Nest Client
body: <p>I am facing problem in filtering the search trying to match list of values.</p>
  
  <p>Here is my Code</p>
  
  <pre><code>List&lt;string&gt; DepartmentIds = new List&lt;string&gt;(){"d1","d2","d3","d4"};
  
  term = "*" + "akshay" + "*"
  
  var searchResults = client.Search&lt;Employee&gt;(c =&gt; c
                            .Index(index)
                            .Type(type)
                            .Query(+q.Term(f =&gt; f.DeptId.ToLower(), DepartmentIds))   // Facing Issue in Matching list of Department IDs
                              &amp;&amp; ((q.Wildcard(wc =&gt; wc.Field(f =&gt; f.FirstName).Value(term)))                        
                                   || (q.Wildcard(wc =&gt; wc.Field(f =&gt; f.LastName).Value(term)))                       
                                   ));
  </code></pre>
  
  <p>Say there are 10 departments and i want to fetch results from department D1,D2,D3 and D4. I should basically see if the department ids in the indexed document matches any of the 4 departments. </p>
  
  <p>As the number of department ids and their values will be dynamic. I want to basically find the equivalent of sql in operator in NEST Client so that i can  filter my search appropriately.</p>