Exporting data from MongoDB within a specific date range using $gt and $lt filters

Question

Exporting data from MongoDB within a specific date range using $gt and $lt filters

Currently attempting to retrieve orders placed on a specific day from my mongodb database using the following mongoexport command:

mongoexport --db store --collection user_data --query "{'order.created_order':{$gt:ISODate("2013-02-05T00:00:00.000Z"),$lt:ISODate("2013-02-06T00:00:00.000Z")}, 'order.status':'paid'}" --out ordersfeb6.json

Encountering an error message as follows:

Thu Feb  7 18:33:43 Assertion: 10340:Failure parsing JSON string near: 'order.cre
0x56a223 0x5712e5 0x53e0f7 0x53e21e 0x8b7739 0x524f2b 0x5258a3 0x7fa7b77bd76d 0x525975 
mongoexport(_ZN5mongo15printStackTraceERSo+0x23) [0x56a223]
mongoexport(_ZN5mongo11msgassertedEiPKc+0xc5) [0x5712e5]
mongoexport(_ZN5mongo8fromjsonEPKcPi+0x377) [0x53e0f7]
mongoexport(_ZN5mongo8fromjsonERKSs+0xe) [0x53e21e]
mongoexport(_ZN6Export3runEv+0x489) [0x8b7739]
mongoexport(_ZN5mongo4Tool4mainEiPPc+0x72b) [0x524f2b]
mongoexport(main+0x23) [0x5258a3]
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xed) [0x7fa7b77bd76d]
mongoexport() [0x525975]
assertion: 10340 Failure parsing JSON string near: 'order.cre

After checking this inquiry mongoexport JSON parsing error, it has come to light that certain parts of mongo queries are assessed using javascript. My question is, do the $gt and $lt operators necessitate javascript for evaluation and could that be causing the issue? If not, I am uncertain about what might be incorrect in my query and any guidance would be highly appreciated. Thank you for your time!

javascript mongodb mongoexport

Answer 1

Answer №1

The main issue at hand is the representation of dates, which must be passed in as Date types and in epoch format. You can try the following:

mongoexport --db store --collection user_data --query '{"order.created_order":{$gt:new Date(1360040400000),$lt:new Date(1360990800000)}, "order.status" : "paid"}' --out ordersfeb6.json

If you need to convert an ISODate to epoch, simply call the date in the shell like this:

> new Date(2013,01,16)*1
1360990800000

To confirm the conversion:

> new Date(1360990800000)
ISODate("2013-02-16T05:00:00Z")

Update: It's worth noting, as pointed out in the comments by imcaptor, that the Month parameter is zero-based (0 = Jan, 11 = Dec) in the Date constructor, which may catch some users off guard. In the example above, I used 01 for February resulting from the zero-based month system.

Answer 2

The main issue at hand is the representation of dates, which must be passed in as Date types and in epoch format. You can try the following:

mongoexport --db store --collection user_data --query '{"order.created_order":{$gt:new Date(1360040400000),$lt:new Date(1360990800000)}, "order.status" : "paid"}' --out ordersfeb6.json

If you need to convert an ISODate to epoch, simply call the date in the shell like this:

> new Date(2013,01,16)*1
1360990800000

To confirm the conversion:

> new Date(1360990800000)
ISODate("2013-02-16T05:00:00Z")

Update: It's worth noting, as pointed out in the comments by imcaptor, that the Month parameter is zero-based (0 = Jan, 11 = Dec) in the Date constructor, which may catch some users off guard. In the example above, I used 01 for February resulting from the zero-based month system.

Exporting data from MongoDB within a specific date range using $gt and $lt filters

Answer №1

Similar questions

Utilizing negative values in lineTo, strokeRect, and fillRect functions

I am facing an issue where the URL generated in the Controller in Laravel is not functioning properly when

Utilizing Weather APIs to fetch JSON data

Trouble with jQuery's .animate function not behaving as expected

The Body Parser is having trouble reading information from the form

Updating an API parameter in React's setState doesn't reflect the new changes

Tips on how to loop through every piece of information within a table

Trouble displaying loaded JSON data with $http GET in ng-table

Converting a JSON object with numerical keys back to its original form

Utilizing Node gRPC for seamless transmission of server metadata to clients without any issues

Ways to retrieve nested data from an object

Insufficient resources - Angular 11 encountering JavaScript heap depletion during ng serve operation

Execute Javascript Code Once Directive Has Finished Rendering the DOM for ShareThis

Experiencing issues with bulk data insertion in MongoDB using Laravel 5

Populating a form field using another input

Fluctuating Visibility with Jquery Show()

JavaScript checking the current page's URL is crucial for maintaining accurate and dynamic

Can images be uploaded via HTTP GET requests?

"Removing an item from an array stored in localstorage: A step-by-step guide

Getting the country code using the ng-intl-tel-input directive