MongoError: Expression $in takes exactly 2 arguments. 1 were passed in

user_13755752 0
Viewed 3979

  • below is my query: while executing below query getting mongoerror : Expression $in takes exactly 2 arguments. 1 were passed in. i am using $in Comparison operator

    {
    "$expr": {
        "$not": {
            "$eq":{
                "$and": [
                    {
                        "PrName": {
                            "$in": [
                                "pname"
                            ]
                        }
                    },
                    {
                        "AccountId": {
                            "$in": [
                                "34562",                      
                                "88765",
                                "87654",
                                "12345"
                            ]
                        }
                    }
                ]
            }
        }
    }
}
aggregation-framework mongodb-query
1 Answers

When you use $expr, the operator expressions syntax changes a little:

{ $in: [ <expression>, <array expression> ] }

{
  "$expr": {
    "$not": {
      "$and": [
        {
          "$in": [
            "$PrName",
            [
              "pname"
            ]
          ]
        },
        {
          "$in": [
            "$AccountId",
            [
              "34562",
              "88765",
              "87654",
              "12345"
            ]
          ]
        }
      ]
    }
  }
}
user_37104900
Related