finding object from array of objects in Mongodb

Question

const Schema = new Schema({
    queueId: {
        type: String,
        required: true,
        index: {
            unique: true
        }
    },
    players: {
        type: [
            {
                ID: {
                    type: String,
                    required: true,
                    index: {
                        unique: true
                    },
                    default: 'null'
                },
                name: {
                    type: String,
                    required: true,
                    default: 'null',
                },
                queueId: {
                    type: String,
                    required: true,
                    default: 'null'
                }
            }
        ],
        required: true,
        default: []
    },
    isAvailable: {
        type: Boolean,
        required: true,
        default: true
    },
    isFull: {
        type: Boolean,
        required: true,
        default: false
    }
});

How do I use findOne() to get the object from players which is an array

Im currently trying this code but it returns null

const doc = await List.findOne({ players: { ID: 'id' } });

basically players is an array and I want to find ID from the players array of objects and get the document.

YuTing · Accepted Answer · 2022-03-04 00:39:08Z

1

db.collection.find({
  "players.ID": "1"
},
{
  "players.$": 1
})

mongoplayground

db.collection.find({
  "players.ID": "1"
})

mongoplayground

db.collection.aggregate([
  {
    $match: {
      "players.ID": "1"
    }
  },
  {
    $unwind: "$players"
  },
  {
    $match: {
      "players.ID": "1"
    }
  }
])

mongoplayground

edited Mar 4, 2022 at 0:39

answered Mar 3, 2022 at 14:32

YuTing

6,6692 gold badges8 silver badges19 bronze badges

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

4 Comments

Firez Over a year ago

Any way to get this using findOne()?

cmgchess Over a year ago

@Firez should work just like the second part of answer

Firez Over a year ago

@cmgchess second part gives an array, I am trying to get an object. I know using [0] (limit will be 1) will give me an object but I would still like to know if I could this in object form.

YuTing Over a year ago

@Firez My third answer use aggregate $unwind

Collectives™ on Stack Overflow

finding object from array of objects in Mongodb

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related