Where query doesn't work on DocumentDB.

[DmitriyNoa]

Hello. I'm migrating the PayloadCMS V3 instance from Mongo Atlas to AWS DocumentDB.

I was able to connect to DocumentDb with following config
mongooseAdapter({ url: process.env.DATABASE_URI || '', disableIndexHints: true, transactionOptions: false, connectOptions: { timeoutMS: 1000, ssl: true, directConnection: true, tlsInsecure: true, retryWrites: false, useFacet: false, } })

The basic CMS UI functionality works.
I'm able to get the documents and edit.

However as soon as I try to use where queries all requests stop working and basically hang until the timeout. Even the default filtration in the UI doesn't work.

Does anyone know how to fix this issue?

P.S. I have my own custom endpoint that is using payload.db. When I use .sort() the query stops working and showing the same issue. But if the .sort() is removed the query works as expected.