How do I get the output field as an array in MongoDb

Question

How do I get the output field as an array.

What I currently have:

db.users.find({ taskIds: { $in: [ObjectId("638764689c4ed1fbff18859a")] } }, {taskIds:1})

The output of it:

[
  {
    _id: ObjectId("638764689c4ed1fbff1885a2"),
    taskIds: [
      ObjectId("638764689c4ed1fbff18859a"),
      ObjectId("638764689c4ed1fbff18859c")
    ]
  }
]

The output I want:

[
  {
     ObjectId("638764689c4ed1fbff18859a"),
     ObjectId("638764689c4ed1fbff18859c")
  }
]

The output you want is not a valid BSON/JSON. An object should have key-value pair. I believe what you want is an array of ObjectId(s). — Yong Shun
– Yong Shun, Commented Dec 3, 2022 at 15:09

Kay · Accepted Answer · 2022-12-03 18:23:24Z

1

If it's just to omit the _id from the result, you need to add it to your projection as follows: db.users.find({ taskIds: { $in: [ObjectId("638764689c4ed1fbff18859a")] } }, {taskIds:1, _id:-1})

This would produce:

[
  {
    taskIds: [
      ObjectId("638764689c4ed1fbff18859a"),
      ObjectId("638764689c4ed1fbff18859c")
    ]
  }
]

answered Dec 3, 2022 at 18:23

Kay

6542 gold badges7 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

How do I get the output field as an array in MongoDb

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