[SOLVED] Combining group and match in query

Technical Issue Reporting
#1

Hi,

I want to combine group by and match, but seems doing something wrong somewhere. Can someone please guide here:

    const pipeline = [
        { 
          match: {trancheId: 2},
          group: { objectId: null, total: { "$sum": { "$toInt" : "$amount"} } } }
      ];
#2

@cryptokid any help here please?

#3

by looking on other posts, like Moralis lookup response
it looks like the syntax needs more {}, like

const pipeline = [
         {  match: {trancheId: 2}},
         { group: { objectId: null, total: { "$sum": { "$toInt" : "$amount"} } } }}
      ];
1 Like
#4

Even this one is also not working:

  const pipeline = [
      {  match: {trancheId: 2 } },
      { group: { objectId: null, total: { "$sum": { "$toInt" : "$amount"} } } }
    ];

The error says:

Cannot read properties of undefined (reading ‘total’)

But if I remove the match block, it works perfectly fine:

  const pipeline = [
      { group: { objectId: null, total: { "$sum": { "$toInt" : "$amount"} } } }
    ];
#5

and if you run only this it also runs perfectly?

#6

your solution actually worked!
trancheId is string, hence needed to pass as string value.

Thanks again man for your prompt response!

1 Like