MongoDB doesn't give me all the documents I request. What's the problem?

Question

MongoDB

There are 2 million documents in my database. Each document in my database has a separate id field which is numbered from 1 to the last document.
Also, each document has a data field which is an array of dictionaries. I need to find all documents, the first dictionary of the data field has a field with a value in my specified range (from 100 to 150 for example).
I send a request to the database {"data.0.value":{$gte:100, $lte:150}}, and the joke is that mongo does not give me all the documents.
I understood this by sorting the results and looking at the id of the very first document, and for some reason it starts with 200000 id. Although before that id there were documents with value lying in the range that we need. Please help me understand why this is happening.

Answer 1

hmm strange, but if you try to paint the request in more detail like this?

$and: [
  {"data.0.value": { $gte:100 } },
  {"data.0.value" :{ $lte:150 } }
]

or if you just select { $gte:100 } and sort by id, will it also start with -_id 200000?

Answer 2

I checked, it still fails.