How to filter nested objects in array of a document in mongoose?

Question

My data stored for user is in the following format :

{
  name: 'XYZ',
  email: 'abc@gmail.com',
  password: 'encrypted',
  categories: [
    {
      name: 'category1',
      type: 'type1',
    },
    {
      name: 'category2',
      type: 'type2',
    }
  ],
  transactions: [
    {
      date: 2020-04-09T06:00:30.000Z,
      type: 'type1',
      category: 'category1',
      description: 'some desc',
    },

    {
      date: 2020-04-08T06:00:30.000Z,
      type: 'type2',
      category: 'category1',
      description: 'some desc',
    },

    {
      date: 2020-04-07T06:00:30.000Z,
      type: 'type3',
      category: 'category1',
      description: 'some desc',
    }
  ]
}

I want to get the data of particular user after providing unique email but along with that I want transactions filtered between 2 dates. Example I want data of user with email = abc@gmail.com and transactions of dates between 2020-04-08 and 2020-04-09.

Sample output looks like this :

{
 name: 'XYZ',
 email: 'abc@gmail.com',
 categories: [...],
 transactions: [
    {
      date: 2020-04-09T06:00:30.000Z,
      type: 'type1',
      category: 'category1',
      description: 'some desc',
    },

    {
      date: 2020-04-08T06:00:30.000Z,
      type: 'type2',
      category: 'category1',
      description: 'some desc',
    }]
}

Or only transactions between the given dates for the given user email is also fine.

Tried using this query

User.aggregate([
    {$match: {email: email}},
    {$unwind: '$transactions'},
    {$match: {'transactions.date': {$gt: startDate, $lt: endDate}}},
    {
      $group: {
        _id: '$_id',
        transactions: {
          $type: "$transactions.type",
          $category: "$transactions.category",
          $date: "$transactions.date",
          $description: "$transactions.decription"
        }
      }
    }
  ]).exec((err, data) => {
    if (err) throw err;
    console.log(data);
  })

Getting the error as follows The field 'transactions' must specify one accumulator

Does this answer your question? [How to filter array in subdocument with MongoDB](https://stackoverflow.com/questions/15117030/how-to-filter-array-in-subdocument-with-mongodb) — whoami - fakeFaceTrueSoul, Apr 11 '20 at 15:30
That's what I want to achieve. But How can I achieve the same using mongoose? — Tushar Tambe, Apr 11 '20 at 15:56
On a mongoose model as like what you do for `.find()` use `.aggregate()` !! It should be simple.. — whoami - fakeFaceTrueSoul, Apr 11 '20 at 15:57
tried using that but stuck on the error `The field 'transactions' must specify one accumulator` — Tushar Tambe, Apr 11 '20 at 16:23
Ok, you don't need to do `$unwind` & all those things, try with `$filter` approach — whoami - fakeFaceTrueSoul, Apr 11 '20 at 16:30

How to filter nested objects in array of a document in mongoose?

0 Answers0