Getting an element from subdocument in mongodb

Question

I would like to retrieve an element from an array subdocument in MongoDB.

This is my current document

  _id: new ObjectId("6175d614c5a8d65745253aca"),
  fullname: "I'm Admin",
  password: '$2b$10$MNsk4ODki0bdSpliKthdb.0KGvy4xkBxxeadfg2TnQAZf810SQ.3q',
  mobile: '88888888',
  email: 'admin@gmail.com',
  accountBalance: 979000,
  __v: 0,
  tradeTransactions: [
    {
      transactionId: 2021-11-02T00:55:52.268Z,
      itemName: 'banana',
      purchasePrice: 1,
      purchaseAmount: 8000
    },
    {
      transactionId: 123,
      itemName: 'apple',
      purchasePrice: 2,
      purchaseAmount: 5000
    }
  ]
}

I want to be able to get

    {
      transactionId: 2021-11-02T00:55:52.268Z,
      itemName: 'banana',
      purchasePrice: 1,
      purchaseAmount: 8000
    }

I tried to use but it doesn't give me the result that I wanted.

const test = user.findOne({"tradeTransactions.transactionId" : "2021-11-02T00:55:52.268Z"}, {"tradeTransactions.$" : 1, "transactionId" : 0})

I also tried but it was giving me a bunch of undefined

user.find({
            "tradeTransactions": {
              $elemMatch: {"transactionId": "123"}
            }
          },
          {"tradeTransactions.$": 1})

Could I please get some guidance?

Thank you very much.

Gabriel · Answer 1 · 2021-11-02T12:41:53.017

0

Try agregate https://mongoplayground.net/p/dDUJO944DIP

user.collection.aggregate([
  { $match: { _id: ObjectId("6175d614c5a8d65745253aca") } },
  { $unwind: "$tradeTransactions" },
  { $match: { "tradeTransactions.transactionId": "2021-11-02T00:55:52.268Z" } },
  { $replaceRoot: { newRoot: "$tradeTransactions" } }
  ])

edited Nov 02 '21 at 12:41

answered Nov 02 '21 at 12:34

Gabriel

670
1
8
24

Thank you for the reply, I tried the code on the link you provided and it was working fine but its not giving me what I wanted in VSCode. I tried ```const response = await user.findOne({"tradeTransactions.transactionId" : transactionID},{'tradeTransactions':currentPrice}).lean(); ``` and its sorta working. – NewbieProgrammer222 Nov 02 '21 at 12:43
try this: `const query = user.collection.aggregate([ { $match: { _id: ObjectId("6175d614c5a8d65745253aca") } }, { $unwind: "$tradeTransactions" }, { $match: { "tradeTransactions.transactionId": "2021-11-02T00:55:52.268Z" } }, { $replaceRoot: { newRoot: "$tradeTransactions" } } ]); const result = await query.toArray();` and result should be an array with your object – Gabriel Nov 02 '21 at 12:52
Thank you so much. This is exactly what I wanted for my project. – NewbieProgrammer222 Nov 02 '21 at 13:01

score 0 · Answer 2 · answered Nov 02 '21 at 12:37

you should use $filter in $project like this

db.collection.aggregate([
  {
    "$project": {
      _id: 0,
      tradeTransactions: {
        "$filter": {
          "input": "$tradeTransactions",
          "as": "t",
          "cond": {
            $eq: [
              "$$t.transactionId",
              "2021-11-02T00:55:52.268Z"
            ]
          }
        }
      }
    }
  }
])

https://mongoplayground.net/p/bUACdhesUI8

Getting an element from subdocument in mongodb

2 Answers2