Get an element from an array of objects with an id in mongodb using nodejs and mongoose

Question

I've a many documents like this

user:62e13ae4f9a38f7610e70bd7,
_id :62e13ae4f9a38f7610e70bdb
transactions:{

 {
            "amount": 50,
            "category": "Bills",
            "type": "Expense",
            "date": "2022-01-20T00:00:00.000Z",
            "_id": "62e13ae4f9a38f7610e70be0"
        },
        {
            "amount": 100,
            "category": "Lottery",
            "type": "Income",
            "date": "2022-01-20T00:00:00.000Z",
            "_id": "62e13ae4f9a38f7610e70be1"
        },
        {
            "amount": 200,
            "category": "Salary",
            "type": "Income",
            "date": "2022-01-20T00:00:00.000Z",
            "_id": "62e13ae4f9a38f7610e70be2"
        }
}

And I want to retrieve an object from the transactions array with a particular id (I only want that object )

I tried some methods like

      const transactions = await Transactions.find({
        user: req.user._id,
        "transactions._id": {$eq: req.params._id },
      });

  const transactions = await Transactions.find({
        user: req.user._id,
        "transactions": { _id: req.params._id },
      });

            const transactions = await Transactions.find({
        user: req.user._id,
        "transactions": { $elemMatch:{_id: req.params._id }},
      });

but nothing seems to be working, can anyone help me to solve this And please mention the mistake I made.

Tamas Szoke · Accepted Answer · 2022-07-27 14:54:00Z

2

Try to match the transactions._id directly:

"transactions._id": req.params._id

Example

const transactions = await Transactions.find({
  user: req.user._id,
  "transactions._id": req.params._id
});

Update

From the comment, it's possible to use projection as the second parameter of .find() to return only the object it found in the transactions.

const transactions = await Transactions.find({
  user: req.user._id,
  "transactions._id": req.params._id
}, { "transactions.$": 1 });

More information

edited Jul 27, 2022 at 14:54

answered Jul 27, 2022 at 14:11

Tamas Szoke

5,5524 gold badges29 silver badges43 bronze badges

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

2 Comments

aravind ks Over a year ago

thanks BTW:) after some modification I got the answer now const transactions = await Transactions.find({ user: req.user._id, "transactions._id":req.params.id , }, { "transactions.$":1 });

Tamas Szoke Over a year ago

Oh, I missed that part, the answer is updated with your solution.

Gibbs · Accepted Answer · 2022-07-27 14:20:18Z

1

If you only want that matching element, you have to use aggreation.

db.collection.aggregate([
{
  $unwind: "$transactions"
},
{
  $match: {
    "transactions.id": "idGoesHere"
  }
}
])

As you commented in the other answer, you could use positional operator to project the matching elements as well.

edited Jul 27, 2022 at 14:20

answered Jul 27, 2022 at 14:11

Gibbs

23.1k14 gold badges84 silver badges147 bronze badges

3 Comments

aravind ks Over a year ago

can tell me what does the $unwind do here

Gibbs Over a year ago

Unwind is an aggregation operator which temporarily reshapes the doc. Means one array element will be one separate doc.

aravind ks Over a year ago

Thanks for the help,but actually i don't need the aggregation here .

Collectives™ on Stack Overflow

Get an element from an array of objects with an id in mongodb using nodejs and mongoose

2 Answers 2

Example

Update

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Example

Update

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related