Uknown operator: $uuid

  • Goal: I would like to successfully query MongoDB for a UUID

  • Steps: I have tried using $uuid which was shown in another post to work, convert to binary subtype 04, imported BSON libraries and UUID libraries, I am just not sure it's possible at this point. Am I really going to have to duplicate every UUID in my database to a string just to be able to find things from retool?

  • Screenshots:

Has anyone successfully performed a find with UUIDs and MongoDB through
Retool?

Hi @RetoolFan64328 Thanks for reaching out! I'm looking into this!

:thinking: I know in the past we've had success with the binary/type 4 approach

Can you also share a screenshot of the schema for this collection in the Retool query editor?

That appears to be the tidbit I needed, when i tried to use $binary, i used subType not type, not sure if that was the only issue, but that seems to have it working for me, thank you!

Glad to hear :slight_smile: