title: Query with $and of two conditions in the same embedded document of an array
body: <p>Let me try to explain my case briefly. I am a total MongoDB novice. I am trying to move away from CouchDB and exploring my options.</p>
  
  <p>A sample document may look like this (shortened, simplified):</p>
  
  <pre><code>{
    exp: [
      {
        isCurrent: true,
        name: 'Name 1'
      },
      {
        isCurrent: false,
        name: 'Name 2'
      }
    ]
  }
  </code></pre>
  
  <p>The index looks like:</p>
  
  <pre><code>{
    "exp.name":1,
    "exp.foo":1,
    "exp.bar":1
  }, {
    partialFilterExpression:{ "exp.isCurrent": {$eq: true}}
  }
  </code></pre>
  
  <p>Yes, "foo" and "bar" do seem redundant but they are part of my current index and I don't think they skew the results.</p>
  
  <p>The idea is to index just the "exp" rows that "are current". Now if I use a query like:</p>
  
  <pre><code>{$and:[{"exp.name":"Name 2"},{"exp.isCurrent":true}]}
  </code></pre>
  
  <p>...the above document still satisfies the query. Why? And more importantly, how can I do what I want to do? Is that even possible? Looks simple and e.g. <code>Google BigQuery</code> would apply <code>$and</code> to fields in the same <code>REPEATED</code> record (and return <strong>NO</strong> results in this scenario).</p>
  
  <p>Alternatively, my "isCurrent: true" is always at [0]. Can I leverage this to write the query accurately and more efficiently?</p>