title: How to add conditional expressions while querying Elastic Search?
body: <p>I want to know if we can write conditional expressions while fetching data from elastic search.</p>
  
  <p>For example - There is a column in the records that I have. The column has integer values from 1 to 100. I want to fetch all such records where that column has even value. Currently, I am doing it like this, building a list of values that I want and then passing them in TermsQuery :</p>
  
  <pre><code> for(int i = 1; i &lt;= 100; i++)
          {
              if (i%2 == 0)
                  possibleMatches.Add(i);
          }
  
          Func&lt;TermsQueryDescriptor&lt;MyClass&gt;, ITermsQuery&gt; TermsQuery = t =&gt;
          {
              return t.Field(f =&gt; f.MyColumn).Terms(possibleMatches);
          };
  
          var results = collection.Search(s =&gt;
                        s.Index(MyIndex).Type(MyElasticsearchType)
                       .Query(qu=&gt;qu.Terms(TermsQuery));
  </code></pre>
  
  <p>Is it possible to write a conditional expression in Terms query or some other query type ? Say something like </p>
  
  <pre><code>t.Field(f=&gt; f.MyColumn%2 == 0)
  </code></pre>