I am new to retool and I am using Mongo Db.
But when I write my nosql queries I get an error message that Json is invalid, yet when I test the same query on compact and on jsonformatter
there is no problem.
I would like to know the reason please
I'm not sure why, but when I do: new Date() (in my sql query) to get the current date, there is an error. What are the date libraries used by Retool on mongoDB?
Hi there! Thanks for reaching out. I'm not entirely sure why your query is throwing an error. Would you be able to share a screenshot of your query and error so we can take a look?
Also, have you taken a look at our documentation for MongoDB integration? It might be helpful: https://docs.retool.com/docs/mongodb
It looks like you're using Classic MongoDB syntax. Our MongoDB integration supports the Extended JSON syntax (v1). I've included a screenshot from our documentation, and you might also find this link helpful: https://www.mongodb.com/docs/manual/reference/mongodb-extended-json-v1/
Let us know if this helps!\