MongoDB: Issue when using mongoexport with --query option

Question

When I try to take backup with mongoexport using the --query option to get the documents whose status is equal to A, facing the below error:

mongoexport --port 27017 --db ex --collection A --type=csv --fields _id,status --query '{"status":"A"}' -o eg.csv

error validating settings: query ''{status:A}'' is not valid JSON

Please let me know how to use --query option.

query looks fine to me. Also there's a typo in query: its fields not fileds. But that wont be related to your original problem — Sarath Nair
– Sarath Nair, Commented Dec 21, 2015 at 10:49
@SarathNair: Thats spelling mistake. But error I'm facing is same. — Ganu
– Ganu, Commented Dec 21, 2015 at 10:59
The same format of command is working for me, can you double check the statement you issued and the one shown here? — Sarath Nair
– Sarath Nair, Commented Dec 21, 2015 at 11:41

Alex · Accepted Answer · 2015-12-21 11:42:04Z

9

Assuming you run this from the DOS command prompt, you need to swap the single and double quotes. You need to wrap the entire query in double quotes and use single quotes inside the JSON document like this:

--query "{'status':'A'}"

I have tested this with mongoexport version 3.0.0 and 3.2.0 and it works for both versions.

answered Dec 21, 2015 at 11:42

Alex

21.9k11 gold badges68 silver badges77 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Hamedz Over a year ago

Without any double quotes is sufficient like this --query {'status':'A'} ,because it's receiving json

Collectives™ on Stack Overflow

MongoDB: Issue when using mongoexport with --query option

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related