How do I limit the properties of a query based of a common subproperty?

Asked Nov 07 '13 at 22:47

Active Nov 07 '13 at 22:47

Viewed 37 times

Given the schema:

{
  _id: ObjectID,
  city: 
   { units: 
      { abc: {},
        def: { tuid : String },
        ...
        xxx: { tuid : String }
   }
}

I would like to return, for a particular _id, all the properties of units who's subproperty tuid is, for example, 123.

I have searched for information about this but array operations keep popping up instead of what I need.

Thank you.

asked Nov 07 '13 at 22:47

Discipol

1

You can't do it in a general way, you need to explicitly include each tuid path using dot notation. – JohnnyHK Nov 07 '13 at 23:24
Then I would need to group them by tuid when adding them but this would cause problems for other operations. Would some sort of aggregation help? @JohnnyHK – Discipol Nov 08 '13 at 08:16

0 Answers0