mongo Using a $match within an $and

Question

I'm trying to use an $and within a $match and can't seem to get it correct. The syntax I'm using isn't correct.

{
"$match":
{
                "$expr": {
                  "$and": [
                    {
                      "$match": {
                        "contra": {
                          "$exists": true
                        }
                      }
                    }
                    ,
                    {
                      "$match": {
                        "$expr": {
                          "$eq": [
                            "$isActivation", true
                          ]
                        }
                      }
                    }
                  ]
                }
}
}

Post full query with some sample documents for correct answer. — Dheemanth Bhat, Mar 12 '21 at 18:20

Dheemanth Bhat · Accepted Answer · 2021-03-12T20:06:27.507

1

Should be as simple as this:

{
    "$match": {
        "contractId": { "$exists": true },
        "isActive": true
    }
}

edited Mar 12 '21 at 20:06

answered Mar 12 '21 at 18:17

Dheemanth Bhat

4,269
2
21
40

1

You can even skip the `$and` – Wernfried Domscheit Mar 12 '21 at 19:51
Oh yes! Got carried away. Thanks. – Dheemanth Bhat Mar 12 '21 at 20:04

mongo Using a $match within an $and

1 Answers1