title: How add less than and greater than in data-config file of solr
body: <p>This is how it goes
  I have two tables </p>
  
  <pre><code>  businessmasters
   Business_id      Business_point
     1                    3.4
     2                    2.8 
     3                    8.0
  
  business_Colors
  business_colors_id   business_rating_from     business_rating_to     rating
     1                         2                           5              OK
     2                         5                           10             GOOD
     3                        10                           15             Excellent
  </code></pre>
  
  <p>I want to link the two tables based business_rating_from and business_rating_to like</p>
  
  <pre><code>        SELECT business_colors_id,business_rating_from,business_rating_to,rating where      
           business_rating_from &gt;= 2 AND business_rating_to &lt; 5;
  </code></pre>
  
  <p>Now i want to index them into solr.This is how my data-config file looks</p>
  
  <pre><code>      &lt;entity name="business_colors" query="SELECT business_colors_id,
   business_rating_from,business_rating_to,business_text,hex_colors,rgb_colors,business_colors_modify
      from business_colors where business_rating_from &amp;gt;= '${businessmasters.business_point}' AND    
      business_rating_to &amp;lt; '${businessmasters.business_point}'"
      deltaQuery="select business_colors_id from business_colors where business_colors_modify &gt;   
     '${dih.last_index_time}'"
      parentDeltaQuery="select business_id from businessmasters where business_point &amp;lt;   
      ${business_colors.business_rating_from} AND business_point &amp;gt;=      
       ${business_colors.business_rating_from}"&gt; 
      &lt;field column="business_colors_id" name="id"/&gt;   
     &lt;field column="business_rating_from" name="business_rating_from" indexed="true" stored="true" /&gt;
      &lt;field column="business_rating_to" name="business_rating_to" indexed="true" stored="true" /&gt;
      &lt;field column="business_text" name="business_text" indexed="true" stored="true" /&gt;
      &lt;field column="hex_colors" name="hex_colors" indexed="true" stored="true" /&gt;
      &lt;field column="rgb_colors" name="rgb_colors" indexed="true" stored="true" /&gt; 
      &lt;field column="business_colors_modify" name="business_colors_modify" indexed="true"     
       stored="true"/&gt; 
  </code></pre>
  
  <p>When i click full indexing data does not get index and no error is shown.
  What is wrong with this,Can any one help and advise.
  How do i achieve what i want to do
  What i have seen is that if i replace AND with OR it works fine.SO why is OR working and AND not working</p>