Using In Query with MongoDb Find operation

Queries and Resources
,
1

I am building a simple dashboard where I have a table and a text input for filtering. When I am trying to filter this table by providing the collection _id value in the query option, MongoDB is not returning anything except that the query is running successfully.
It works fine if I change the property "_id" to something else. I also tried to test with the Objectid method but, it gives me a JSON parsing error.

image
image1160×711 41.3 KB

2

You need to use Extended Json format v2:

{
  _id: {
    "$oid": "object id here as string"
  }
}

More info: https://docs.retool.com/docs/mongodb