mongodump 导出条件错误

Question

mongodump or mongoexport use --query,but have not filtered the result, it exports all data.
my condition is like this:

{"modifiedOn" : ISODate("2018-06-06T00:00:12.539+0000")}

and i change it is to 1528244529
but when i use this:

mongodump -h 192.168.169.63:27017 -d product_operation_sold -c ebay_payment --query '{"modifiedOn":{$gt: Date(1528244529)}}' -o /root

what was am I doing my wrong?

Answer 1

Try using $date instead of Date/ISODate when using with bash tools:

mongodump -h 192.168.169.63:27017 -d product_operation_sold -c ebay_payment --query '{"modifiedOn":{$gt: {$date: "2018-06-06T00:00:12.539Z"}}}' -o /root

This also applies to following tools:

• mongodump
• mongorestore
• mongoimport
• mongoexport