When I query all the records, i get the results as shown below.

When i copy an ID from the result and add it in the filter, no result is found.

Here is the example filter from documentation

What am i doing wrong? mongo db got to be kidding me :/

CodePudding user response：

You are not providing the data type with the query. Since your _id field is ObjectId type and you are comparing as string that is why it is not working. Change your filter condition and convert your string id to ObjectId type.

{_id: ObjectId('yourId')}

MongoDB provides an automatic unique identifier for the _id field in the form of an ObjectId data type.

CodePudding user response：

There could be a few reasons why the filter is not working in MongoDb Compass:

1. The filter syntax is incorrect: Make sure that you are using the correct syntax for your filter. You can refer to MongoDb's documentation for more information on filter syntax.
2. The collection is not selected: Make sure that you have selected the correct collection that you want to filter.
3. The filter is not applied to the correct field: Make sure that you are applying the filter to the correct field in the collection.
4. There is a problem with the connection: Make sure that you are connected to the correct server and that the connection is stable.
5. The filter is not compatible with the version of Compass you are using: Make sure that you are using the latest version of Compass and that the filter is compatible with it.

If none of these steps resolve the issue, you can try restarting Compass or reaching out to MongoDb support for further assistance.