title: Firestore error: Cannot use multiple conditional where clauses on different properties
body: <p>I'm tring to use multiple &quot;where&quot; filters on Firestore query, My query is based on the above <a href="https://stackoverflow.com/questions/48036975/firestore-multiple-conditional-where-clauses">example</a>.</p>
  <p>My query:</p>
  <pre><code>let colRef = firebase.firestore().collectionGroup('volumes')
  colRef = colRef.where('days', 'array-contains', day)
  colRef = colRef.where('start_time', '&lt;=', time)
  colRef = colRef.where('end_time', '&gt;', time)
  colRef = colRef.where('volume', '&gt;', 0)
  const snapshot = await colRef.get()
  </code></pre>
  <p>I'm receiving the above error:</p>
  <blockquote>
  <p>Error: 3 INVALID_ARGUMENT: Cannot have inequality filters on multiple
  properties</p>
  </blockquote>
  <p>I have checked about <a href="https://firebase.google.com/docs/firestore/query-data/queries#compound_queries" rel="nofollow noreferrer">compounding Firestore queries</a> and I found out that:</p>
  <blockquote>
  <p>You can perform range (&lt;, &lt;=, &gt;, &gt;=) or not equals (!=) comparisons only on a single field</p>
  </blockquote>
  <p>It's a huge limitation to Firestore queries. Am I missing an another option to implement that query?</p>
  <p>Thanks!</p>