How to update subarray field of array in mongodb

Question

My object looks like this:

Stats = {
  name: 'filters'
  variants: [
    {
      variant: 'A'
      displayed: 123
      actions: [
        {
          name: 'clicked'
          triggered: 12
        }

      ]
    },
    {
      variant: 'B'
      displayed: 123
      actions: [
        {
          name: 'clicked'
          triggered: 12
        }
      ]
    }
  ]
}

I have an array of variants and inside it array of actions. I would like to increment triggered field for selected variant and actions.name. I am using that in meteor.js.

My find query looks like below:

Stats.find({
  name: 'filters', 
  variants: {
    $elemMatch: {
      variant: 'A',
      'actions.name': 'clicked'
}}})

Now if object exists I would like to do something like below, but I know it doesn't work.

Stats.update({
  name: 'filters', 
  variants: {
    $elemMatch: {
      variant: 'A',
      'actions.name': 'clicked'
}}},
{
  $inc: {
    'variants.$.actions.$.triggered': 1
}})

I know that the positional $ operator acts as a placeholder for the first match of the update query selector. But maybe you have any other idea how to do it?

Doesn't seem to be a way to do this. A similar question was asked just yesterday: stackoverflow.com/q/15236322/1259510 — JohnnyHK
– JohnnyHK, Commented Mar 7, 2013 at 13:27

krzysu · Accepted Answer · 2013-03-07 16:14:21Z

1

I ended up with flattening the structure to:

Stats = [
  {
    name: 'filters'
    variant: 'A'
    displayed: 123
    actions: [
      {
        name: 'clicked'
        triggered: 12
      }
    ]
  },
  {
    name: 'filters'
    variant: 'B'
    displayed: 123
    actions: [
      {
        name: 'clicked'
        triggered: 12
      }
    ]
  }
]

and here I can increment the triggered value easily:

Stats.update({
  name: 'filters',
  variant: 'A',
  'actions.name': 'clicked'
}, {
  $inc:  {
    'actions.$.triggered': 1
}})

I am using this code on server side only. Anyway, thanks for help!

answered Mar 7, 2013 at 16:14

krzysu

4024 silver badges9 bronze badges

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

Comments

Tarang · Accepted Answer · 2013-03-07 12:33:50Z

0

At the moment the $ operator isn't available on minimongo and even on the server there are a couple of glitches with it (at least when I used it last).

Its a known issue and it looks like it may be fixed soon: https://github.com/meteor/meteor/issues/153

answered Mar 7, 2013 at 12:33

Tarang

76.1k39 gold badges220 silver badges279 bronze badges

Collectives™ on Stack Overflow

How to update subarray field of array in mongodb

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related