title: How applying logical AND (&&) in firestore query
body: <p>I want to merge these queries with AND logical operator, so I just get the data that fulfilled these 2 conditions</p>
  <pre><code>.where(&quot;sportType&quot;, &quot;in&quot;, sportFilter)
  .where(&quot;floorType&quot;, &quot;array-contains-any&quot;, floorFilter)
  </code></pre>
  <p>I was trying using nested <code>where</code> like this</p>
  <pre><code>                ref
                  .where(&quot;sportType&quot;, &quot;in&quot;, sportFilter)
                  .where(&quot;floorType&quot;, &quot;array-contains-any&quot;, floorFilter)
                  .onSnapshot((snapshot) =&gt; {
                      snapshot.forEach((doc) =&gt; {
                          items.push(doc.data())
                      })
                      setLoading(false)
                  })
  </code></pre>
  <p>but it comes to an error like:</p>
  <pre><code>FirebaseError: Invalid query. You cannot use 'array-contains-any' filters with 'in' filters.
  </code></pre>
  <p><strong>EDIT</strong></p>
  <p>this is my collection structure, I want to get a document that has sportType Futsal and floorType Grass</p>
  <pre><code>[
  {
      name: &quot;Golden Goal&quot;,
      sportType: &quot;Futsal&quot;,
      floorType: &quot;Grass&quot;
  },
  {
      name: &quot;Goalie&quot;,
      sportType: &quot;Football&quot;,
      floorType: &quot;Grass&quot;
  },
  {
      name: &quot;Gold&quot;,
      sportType: &quot;Futsal&quot;,
      floorType: &quot;Vinyl&quot;
  },
  ]
  </code></pre>