title: Flutter Firebase where clause mixing between isNotEqualTo and isEqualTo clauses causes data to not showed up
body: <p>I'm still learning about Flutter with firebase.</p>
  <p>So, I want to make a to-do-list (TDL) app, that can shows TDL item in the home page.</p>
  <p>TDL can have 1 of these 3 status (<em>selesai</em> [finished], <em>belum</em> [not yet], <em>telat</em> [late]),
  and i wanted to show the ones which status is <em>belum</em> and <em>telat</em>, or simply the ones which status is not equal to <em>selesai</em>, and has the idProject equal to &quot;0&quot;.</p>
  <p>Simply i need to show TDL which has idProject = &quot;0&quot; and status!=&quot;selesai&quot;.</p>
  <p>So i wrote this:</p>
  <pre><code>  static Stream&lt;QuerySnapshot&gt; getDataTDL() {
      return CToDoList
      .where(&quot;status&quot;,isNotEqualTo:&quot;selesai&quot;)
      .where(&quot;idProject&quot;,isEqualTo: &quot;0&quot;)
      .snapshots();
    }
  </code></pre>
  <p><a href="https://i.stack.imgur.com/q2u2Z.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/q2u2Z.png" alt="enter image description here" /></a></p>
  <p>here's a quick look on my data at firebase.. So, basically it should at least return this one -<em>actually there's few more datas it can return</em>- because it matched my where-clause requirements, but in fact it returns nothing at all.</p>
  <p>So what can i do now?</p>