title: Firebase database query with multiple condition
body: <p>i am straggling for two days trying to find a proper solution to query Firebase database with multiple condition, and filter to be done on the server side not the client side as i have a huge amount of records, the below is my schema, trying to query where <strong>journeyId</strong>=$journeyId and <strong>date</strong> BETWEEN $date1 AND $date2;</p>
  <pre><code>{
    &quot;-MdqIEA4CwKH29PMG0Op&quot; : {
      &quot;comment&quot; : &quot;&quot;,
      &quot;date&quot; : 1625482389127,
      &quot;device&quot; : &quot;iPhone 11&quot;,
      &quot;journeyId&quot; : &quot;eTopup_mobile_iOS&quot;,
      &quot;os&quot; : &quot;iOS 14.6&quot;,
      &quot;rating&quot; : 4
    },
    &quot;-MeAagXopUMzptv-koPA&quot; : {
      &quot;comment&quot; : &quot;&quot;,
      &quot;date&quot; : 1625839812343,
      &quot;device&quot; : &quot;iPhone 7 Plus&quot;,
      &quot;journeyId&quot; : &quot;eTopup_mobile_ANDROID&quot;,
      &quot;os&quot; : &quot;iOS 14.6&quot;,
      &quot;rating&quot; : 4
    },
    &quot;-MeJX9PBaP3xGx255Pv9&quot; : {
      &quot;comment&quot; : &quot;&quot;,
      &quot;date&quot; : 1625989619199,
      &quot;device&quot; : &quot;iPhone XR&quot;,
      &quot;journeyId&quot; : &quot;eTopup_WEB&quot;,
      &quot;os&quot; : &quot;iOS 14.6&quot;,
      &quot;rating&quot; : 5
    }
  }
  </code></pre>