title: Range search using solr_query on cql shell
body: <p>We are trying to pull data from cassandra-solr node with date ranges using solr query.</p>
  
  <pre><code>e.g.
  
  SELECT *  FROM keyspace_name.table_name where solr_query='{"q":"&lt;col1&gt;:*",,"sort":"col1 asc"}';
              I could find syntax for apache solr documentation to perform range search &amp; examples too.
  </code></pre>
  
  <p>In case of Datastax Solr DSE search syntax for multiple conditions/date filters is not available  </p>
  
  <p><a href="https://docs.datastax.com/en/datastax_enterprise/4.6/datastax_enterprise/srch/srchCql.html" rel="nofollow">https://docs.datastax.com/en/datastax_enterprise/4.6/datastax_enterprise/srch/srchCql.html</a></p>
  
  <p>I couldn’t find any documentation for Datastax Solr for following things specifically.</p>
  
  <ol>
  <li>1)“fq” with multiple parameters   2) Syntax for date ranges.<br>
      3)Date    formats &amp; syntax to specify them using solr_query</li>
  </ol>
  
  <p>Please let me know if i can refer to any source other than Datastax Solr documentation for syntax &amp; examples for firing query with parameters </p>
  
  <p>To find data between two dates.</p>
  
  <blockquote>
    <p>Equivalent cql query:</p>
  </blockquote>
  
  <pre><code>select * from tableName where startdate &gt;= '1987-19-09 11:14:00+0000' AND  startdate &lt; '2003-10-06 08:42:00+0000' limit 500 allow filtering;
  </code></pre>
  
  <p><strong>Please help.
   Thanks
  Saurabh</strong></p>