Find all documents where a sub-array element matches "nan"

Question

I have a bunch of documents that look like this

{
  "coordinates": [[1, 2], [nan, nan]  ]
}

I would like to filter and find all documents where one of those arrays contains nan values like in the example.

score 1 · Answer 1 · answered Jul 06 '16 at 19:01

1

$elemMatch with $in query will also filter, check below query

db.collection.find({"coordinates":{"$elemMatch":{"$elemMatch":{"$in":["nan"]}}}})

answered Jul 06 '16 at 19:01

Yogesh

score 0 · Answer 2 · answered Jul 06 '16 at 18:22

0

If you always have pairs in your inner arrays then

db.yourColl.find({coordinates: [NaN, NaN]})

should do the job

answered Jul 06 '16 at 18:22

DAXaholic

1

This will fail if only one element in the sub-array is NaN – styvane Jul 06 '16 at 18:26
1

Therefore I wrote if you have pairs ... The sample data shows it like that so I gave this answer. – DAXaholic Jul 06 '16 at 18:27

2 Answers2