Increment or insert mongo nested array values

Question

I have a collection with such documents stuct:

{ 
  id: 1, 
  my_field: [
    { 
      date: date1, 
      type: A,
      value: 1
    }, 
    { 
      date: dateX, 
      type: X, 
      value: Z
    }, 
    ...
  ]

What the problem i solve: I have id, date, type and value. I have to find document by id(which is always present), then element in my_field by date and type and increment value. If this element doesnt present in my_field i have to insert it(struct to my_field). And i look for the most efficient way

I will be very thankful for ideas!

Mongo 4.2

Also it will be great if someone helps with to write this on ruby-driver for mongo :)

Thanks!

Here is a similar post: [mongoose update array or add to the array](https://stackoverflow.com/questions/61234012/mongoose-update-array-or-add-to-the-array). — prasad_, Apr 24 '20 at 03:12

score 0 · Answer 1 · answered Apr 23 '20 at 21:20

0

Use find-and-modify and $push.

answered Apr 23 '20 at 21:20

D. SM

13,584
3
12
21

Increment or insert mongo nested array values

1 Answers1