MongoDB (Java driver) add element in a sub sub collection in one go

Question

I have a document that looks like this:

{
 "id":1,
 "layers": 
           [{
            "id" : 100,
            "files": [{
                       "id":1,
                       "name":"test"
                     }]
            }]
   }

@Document(collections="tests")
public class Test() {
   string id
   Set<..> layers;
}

public class Layers() {
 List<..> files;
}

Is it possible (given a documentId and and layerId) to add a new file object in one query ? something like

db.test.update(
  { _id: 1 },
  { $push:
     {
       "layers.100.files": {"id":2,"name":"test2:}
     }
  }
)

when I try the above I get an error like: cannot use the part (contentLayers ....) to traverse the element ....

Alexis · Accepted Answer · 2015-10-26 13:13:56Z

2

db.test.update(
  { $and: [{_id: "1"}, {"layers.id": "100" }]},
  { $push:
     {
       "layers.$.files": 1
     }
  }
)

Here is the version non-java, the important point is having this $ before the array

Note there 'might' be an other way of doing this but the above works for me

edited Oct 26, 2015 at 13:13

answered Oct 26, 2015 at 12:56

Alexis

1,8625 gold badges26 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MongoDB (Java driver) add element in a sub sub collection in one go

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related