Unwind does not show all data

Question

I have a collection which looks like this:

{

  "consultation_type" : "1",
  "encounter_id" : "12345"
}

I am applying the following query:

db.encounter.aggregate([{ "$unwind" : "$vitals"},{ "$match" : { "$eq" : [ "$vitals.spirometer.FVC" , "null"]}},{$limit:1}])

but I don't get any result. Is there something wrong in my query?

I add to fix your document, as you missed the } for "test". – Derick Aug 12 '13 at 09:03 — Derick, Aug 12 '13 at 09:03

score 1 · Accepted Answer · answered Aug 12 '13 at 09:03

1

With your aggregate command, I get the error:

Mon Aug 12 10:01:01.269 JavaScript execution failed: aggregate failed: { "errmsg" : "exception: bad query: BadValue unknown top level operator: $eq",

You shouldn't need $eq, but instead do:

db.encounter.aggregate( [
    { "$unwind" : "$vitals" },
    { "$match" : { "vitals.spirometer.FVC" : "null" } },
    { $limit : 1 }
] )

$eq is only used for in conditions.

answered Aug 12 '13 at 09:03

Derick

In that case how can I implement not equal ("$neq") – Phalguni Mukherjee Aug 12 '13 at 09:59
Just like with any other find query: ``{ "vitals.spirometer.FVC" : { $neq: "null" } }`` – Derick Aug 12 '13 at 10:34

1 Answers1