Find objects where none of "result" fields is equal to specific value

Working with Data
1

Hi, I have an object that has many fields called “result”. How can I find all object that does not contain any result field that is equal to specific value?
All my attempts ended with returning all objects that inclueded at least one result field not equal to specific value…

eg:

{
    "name": "London",
    "models": [{
        "result": "5"
    }, {
       "result": "9"
    }, {
       "result": "20"
    }]
}
2

Hello @Daniel_Reznicek, welcome to the community.

You can try this query:

db.test.find( { "models.result": { $ne: "200" } } )

This finds the documents that does not contain any result field that is equal to specific given value, "200".