Simple query..but how?

in m001 Atlas we have results.scores.

How to create a query that selects only those elements for results that are in specific range?(70-80)

Answering to myself :slight_smile:

{$nor:[{results:{$gte: 80}}, {results:{$lt: 70}}]}

This will return elements where all items of results array matching the range 70-80

Hi @Vitaly_13280,

Please recheck your query. You can refer to the following docs for better understanding the usage of the operators and form the query:

To verify your query, the count of documents that contain at least one score in the results array that is greater than or equal to 70 and less than 80 should be 744.

I hope it helps. If you still face any problem, please let me know.

Thanks,
Sonali