Error on MongoDB queries

martincrb · July 20, 2021, 2:16pm

Hi all!
Since some hours ago, we started viewing this error on some retool dashboards that run queries against a MongoDB Database:

- message:"Cannot convert undefined or null to object"

We made no changes on our side and can confirm that it was working yesterday. Is there something we can do to try to fix the problem? Appreciate the support!

Best,

Tess · July 20, 2021, 11:48pm

Hi @martincrb! Welcome to the community! I believe this is related to a bug that was fixed this morning (a few hours after your post). Are you still seeing any errors in your app?

martincrb · July 21, 2021, 9:46am

Hi @Tess , thank you very much! I can confirm it is working now

Really appreciate the support.

Best,

Tess · July 21, 2021, 4:31pm

Wonderful! Let us know if any other questions come up!

Doglas · August 23, 2022, 5:32pm

Hi @Tess ,

What version has this fix?

Tess · August 23, 2022, 5:47pm

Hi @Doglas Thanks for reaching out! I believe this was fixed on Retool Cloud 2.72, but I don't believe this bug made it to any of our on-premise deployments. Let us know if you're seeing any issues!

Doglas · August 23, 2022, 7:01pm

Yes, I have.

I am building a aggregate pipeline on mongodb and using this $match: { chaveProduto: { $in: [null, undefined] } }.

I receive this message: "The value has to be of type 'object | void', you provided a value of type 'string'

When I remove the 'undefined', it runs.

Tess · September 2, 2022, 9:46pm

Hi @Doglas! Thanks for reaching out. Looking at this doc, I believe null can be used to find both null & undefined

Combined:

Null only:

Undefined only: