MongoDB: Find documents which has exact array values and size

In the comments you clarified that this is the behavior that you are looking for:

"i want if all the elements are matching then return me the record."

This means that your current query does not work as it returns this document:

  {
    "_id": ObjectId("6395b0d9d35a57df142862dd")
    "users": [
      ObjectId("63844feadf507942caaf90e3"),
      ObjectId("638455e5fa983e9cf84c0f3f")
    ],
    ...
  }

But that document contains an entry of ObjectId("63844feadf507942caaf90e3") in the users array which you don’t want.

One solution here is to use the $allElementsTrue operator. This component of the check would look something like this:

        "$allElementsTrue": [
          {
            "$map": {
              "input": "$users",
              "in": {
                "$in": [
                  "$$this",
                  [
                    ObjectId("638455e5fa983e9cf84c0f3f")
                  ]
                ]
              }
            }
          }
        ]

What the approach above does is map over the users array to make sure that each entry is present in the array provided by the client. Here the list from the $all in the original question is placed as the second argument to $in.

An alternative approach, would be to use the $setDifference operator. That might look as follows:

        $not: {
          $size: {
            "$setDifference": [
              "$users",
              [
                ObjectId("638455e5fa983e9cf84c0f3f")
              ]
            ]
          }
        }
      }

Here we are computing the logical difference between the array in the documents and the array passed into the query. We then check that output to see that the difference is empty (via the negation of the size).

but still its going in agg only right? anything in find query?

What is the requirement for doing this outside of aggregation?

Regardless, these operators are not actually restricted for use solely within the aggregation framework. Via the $expr operator we can use them inside of find() directly.

Therefore the full example for the first approach is as follows (playground example here):

db.conversations.find({
  $expr: {
    "$allElementsTrue": [
      {
        "$map": {
          "input": "$users",
          "in": {
            "$in": [
              "$$this",
              [
                ObjectId("638455e5fa983e9cf84c0f3f")
              ]
            ]
          }
        }
      }
    ]
  },
  users: {
    $size: 2
  }
})

And the second approach (playground example here):

db.conversations.find({
  $expr: {
    $not: {
      $size: {
        "$setDifference": [
          "$users",
          [
            ObjectId("638455e5fa983e9cf84c0f3f")
          ]
        ]
      }
    }
  },
  users: {
    $size: 2
  }
})