How to query and fetch one item that is in an array from mongodb?

Question

I'm new to MongoDB/Mongoose and I am using MongoDB, Node and Express how to query and fetch one item that is in an array from mongodb?

Here is the database structure

{
       "_id" : ObjectId("5e19d76fa45abb5d4d50c1d3"),
       "name" : "Leonel Messi",
       "country" : "Argentina",
       "awards" : [ "Ballon d'Or", "Golden Boot", "FIFA World Player of the Year",]
}

Here is the query using mongoose and express in node js environment

router.get('/FindPlayers', async (req, res) => {

const player = await Players.findOne({ name: "Leonel Messi" }, { country: 1, awards: [0], _id: 0, });

  res.send(player);
});

I would like to get the county and the first item in the awards array only like this below

{
  country : "Argentina",
  awards : [ "Ballon d'Or" ]
}

But instead I am getting

{
  country : "Argentina",
  awards : [ 0 ]
}

Dheemanth Bhat · Accepted Answer · 2021-04-03 18:16:50Z

1

try this:

const player = await Players.findOne(
    {
        name: "Leonel Messi"
    },
    {
        country: 1,
        awards: { $arrayElemAt: ["$awards", 0] },
        _id: 0
    }
);

// or

const player = await Players.findOne(
    {
        name: "Leonel Messi"
    },
    {
        country: 1,
        awards: { $first: "$awards" },
        _id: 0
    }
);

answered Apr 3, 2021 at 18:16

Dheemanth Bhat

4,5022 gold badges30 silver badges43 bronze badges

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

Collectives™ on Stack Overflow

How to query and fetch one item that is in an array from 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