How do I change the value in an array? Mongoose [duplicate]

Question

How do I change the level value to the number 2 in the users array for a user with uid: 543? (Mongoose)

Sample code:

[
  {
    "id": 1,
    "name": "Check",
    "balance": 1,
    "tokens": 2,
    "energy": 2,
    "ownerid": 623465,
    "users": [
      {
        "cid": 1285931,
        "uid": 0,
        "level": 3
      },
      {
        "cid": 3272234,
        "uid": 631,
        "level": 1
      }
    ]
  },
  {
    "id": 2,
    "name": "Check2",
    "balance": 5,
    "tokens": 12,
    "energy": 51,
    "ownerid": 171412,
    "users": [
      {
        "cid": 1874345,
        "uid": 543,
        "level": 3
      },
      {
        "cid": 2434512,
        "uid": 212,
        "level": 1
      }
    ]
  }
]

J.F. · Accepted Answer · 2021-01-24 19:30:59Z

1

You have to use positional operator in this way:

With this query you are telling mongo that found the element where users.uid is 543 and then set the value where the query match (i.e. where users.uid is 543) to 2.

db.collection.update({
  "users.uid": 543
},
{
  "$set": {
    "users.$.level": 2
  }
})

Example here

answered Jan 24, 2021 at 19:30

J.F.

15.3k10 gold badges41 silver badges74 bronze badges

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

Collectives™ on Stack Overflow

How do I change the value in an array? Mongoose [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related