I cant write a mongoDB Aggregate

hi
when I try to write an aggregate to my DB I will give “internal error”
-my credentials is ok
-this is my node :point_down:

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:

hello @amir

The correct syntax should be like that:

yes it works but I have a new problem now

this is my new query and it woerks on my query console
but not on n8n
I think this is about double quotes in line4 and it doesn’t understand my date in this syntax
but I don’t know how to write it right

I don’t have Mongo, so I can’t test it.

have you tried to escape the double quotes with the backslash? E.g.
"ISODate(\"2024-07-05T18:35:28.349Z\")"