Mongoexport failed by date

Daniel_Ponce · 2024-07-20T11:43:22.521Z

The export fails, in a previously published post it was said that it worked

Query syntax for mongoexport Developer Tools

Hi, I’m trying to pass in a query to mongoexport like this: mongoexport --uri=“mongodb+srv://dev:removed@server/feedback” --collection=entries --query=’{ “date”: { “$lt”: { “$date”: “2020-02-28T00:00:00.000Z” } } }’ --out=dispatcher.json But I am getting an error: 2020-07-28T12:43:39.366+0100 query ‘[123 32 100 97 116 101 58 32 123 32 36 108 116 58 32 123 32 36 100 97 116 101 58 32 50 48 50 48 45 48 50 45 50 56 84 48 48 58 48 48 58 48 48 46 48 48 48 90 32 125 32 125 32 125]’ is not valid …

It doesn’t work for me
mongoexport --db TEST–username user01–authenticationDatabase admin --collection history
–query=‘{“createAt”: {“$lt”: {“$date”: “2020-10-07TT00:00:00.000Z”}}}’
–type json
–out=/data/db/dump/full_col_activities_hoy.json

Stanimira_Vlaeva · 2024-07-21T15:06:54.316Z

Hi Daniel,

What’s the error you’re getting when you run the command?

It seems there are a few issues with the command you’re using, possibly due to how it was formatted in the forums. Here’s a corrected version that works for me:

mongoexport --db TEST --username user01 --authenticationDatabase=admin --collection history
--query='{"createAt": {"$lt": {"$date": "2020-10-07TT00:00:00.000Z"}}}'
--type=json
--out=/data/db/dump/full_col_activities_hoy.json

Note that the field createAt might be a typo of createdAt.

Daniel_Ponce · 2024-07-24T14:23:06.639Z

Thank you Stanimira, take the test and comment on the results

Daniel_Ponce · 2024-07-25T15:26:30.552Z

Hello Stanimira_Vlaeva,
I had to use the --queryFile clause and create a json file with the instruction gte date1 and lt date2, that’s how it worked for me.

thank you for your valuable help