[SERVER-4261] mongoexport query doesn't support advanced queries Created: 11/Nov/11  Updated: 06/Dec/14  Resolved: 22/Jun/12

Status: Closed
Project: Core Server
Component/s: Tools
Affects Version/s: 2.0.1
Fix Version/s: None

Type: Bug Priority: Trivial - P5
Reporter: David Dunlop Assignee: Unassigned
Resolution: Done Votes: 2
Labels: neweng
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Backwards Compatibility: Fully Compatible
Operating System: Linux
Participants:

 Description   

When I try and do a mongoexport using an an advanced query, I get 0 records even if there are matching objects.

mongoexport --csv -h localhost -d contents -c Author -q "{'facebookName':{'$ne':null}}" -f profileUrl,facebookName

I tried a few of the other dollar operators such as $in and $nin and they all appear to have the same result.



 Comments   
Comment by Yoft [ 06/Dec/14 ]

I'm facing this error with :

mongoexport --db fscrap --collection Wall -q "{\$or : [{'insert_time' : {\$gte : new Date(1393624800000)} },{'comments.comment_time' : {\$gte : new Date(1393624800000)}}]}" --out test.json

even with escaping I'm getting zero records while the query WORKS in mongo shell

Comment by Dwight Merriman [ 22/Jun/12 ]

you need to escape the $ character in some shells.

$ echo "{'facebookName':{'$ne':null}}"
{'facebookName':{'':null}}
$ echo "{'facebookName':{'\$ne':null}}"
{'facebookName':{'$ne':null}}

Comment by Erick Ruiz de Chavez [ 29/May/12 ]

I am having problems with a big query, same one worked perfectly on the Linux server.

Command

mongoexport --host repset/server1,server2,server3 --db somedb --collection somecollection --query '{"_id":{"$in":[ObjectId("4f9184671472321f78bab744"),ObjectId("4f918a05be6eaf147876f56c"),ObjectId("4f91afc269e6115b0cde666f"),ObjectId("4f91b60682718239528a134d"),ObjectId("4f95841b85d671614ddaf6a6"),ObjectId("4f98ffbc41c7985843ed4900"),ObjectId("4f9d9e8e1d8cde314e438646"),ObjectId("4f9edc34df41aab00ffc52f6"),ObjectId("4fa0c720e43f2b804d64c38b"),ObjectId("4fa0c80a4880bd8f4d096d27"),ObjectId("4fa0c93e4880bd8f4d09ffa2"),ObjectId("4fa2f28ec7b480a466ec2672"),ObjectId("4fa2f620fcd694a97a7915ca"),ObjectId("4fa444e377d839673cb27302"),ObjectId("4fa80fd06c1d33a419bde3f4"),ObjectId("4fa91116ad3b5e1564f5fa93"),ObjectId("4fa9640ab74b4997195f51e1"),ObjectId("4faa9470dc2022ba69239c5c"),ObjectId("4faab00c6c1d33a419b23a8e"),ObjectId("4faab79aead3a2a319a9b1a6"),ObjectId("4facb958f10e0bf84449887e"),ObjectId("4facba56480938f9443b6bc8"),ObjectId("4fad31ccd424305974a55f97"),ObjectId("4fad3c01d424305974b4f97b"),ObjectId("4fad425dd424305974c65e74"),ObjectId("4fad86c1070a209819a259b3"),ObjectId("4fae7a403420e8a10500d969"),ObjectId("4faf3acb0390ae3d67000968"),ObjectId("4fb13f7fd795811322088594"),ObjectId("4fb1b641b0280d2d4b00c66b"),ObjectId("4fb1c9a8474d4f2a4b019ede"),ObjectId("4fb236f3ed79638b1501b740"),ObjectId("4fb25573be65869377080e8c"),ObjectId("4fb25f44ba71c9a441006abc"),ObjectId("4fb415714288f4a61f1103e5"),ObjectId("4fb4e846892ef42a16023952"),ObjectId("4fb55010ae1160bd1403d03e"),ObjectId("4fb553ca26af85d82400192e"),ObjectId("4fb9078253f808b16a02d82a"),ObjectId("4fbc044fb011b8353a156de0"),ObjectId("4fbc06a66af6d3e579013ddc"),ObjectId("4fbc7812e96ae1f84c11fb4a"),ObjectId("4fbc8dd56af6d3e57901d7a3"),ObjectId("4fbc8e396e5372346f010c8d"),ObjectId("4fbc8fc96e5372346f01103e"),ObjectId("4fbc9088acfe3d482502a75c"),ObjectId("4fbc90b1a0a0acc24906eb55"),ObjectId("4fbc9220ec2181161d03e9fc"),ObjectId("4fbcbbaaa0a0acc24918455e"),ObjectId("4fbce4428bcfdefb54032b24"),ObjectId("4fbce470a0a0acc2491934bd"),ObjectId("4fbe7bfed0c89fc428010ec0"),ObjectId("4fbe8c6d95266c46790d220a"),ObjectId("4fbf405bdeff1f4944011048"),ObjectId("4fbfb0b84325335f5e034575"),ObjectId("4fbfb402410bde5d5e04abc7"),ObjectId("4fbfe9330406e2605e0c6338"),ObjectId("4fbff1feb424611e5911b1e5"),ObjectId("4fbff432666a595e5e08296a"),ObjectId("4fbff5ba666a595e5e082990"),ObjectId("4fc0458cdf8b454644044a5d"),ObjectId("4fc046579fe5e24844063c1f"),ObjectId("4fc04a9a92aa62474404a6d1"),ObjectId("4fc06546b49af55a3c090ef0")]}}' --out somefile.json

Windows output

Tue May 29 16:29:07 [ReplicaSetMonitorWatcher] starting
connected to: repset/server1,server2,server3
Tue May 29 16:29:07 Assertion: 10340:Failure parsing JSON string near: '{_id:{$in
assertion: 10340 Failure parsing JSON string near: '{_id:{$in

Linux output

Tue May 29 11:28:34 [ReplicaSetMonitorWatcher] starting
connected to: repset/server1,server2,server3
exported 64 records

Comment by Colin Marc [ 07/Feb/12 ]

I'm also having the same issue: exported 0 records. I tried with a very simple $or (always returns everything on the command line).

$ /opt/mongodb/bin/mongoexport -vvvvvvv -h localhost:30000 -d lumberjack -c aggregates -q "{'$or': [{}]}" --csv -f s,c -o export.csv
Tue Feb 7 22:58:55 creating new connection to:localhost:30000
Tue Feb 7 22:58:55 BackgroundJob starting: ConnectBG
Tue Feb 7 22:58:55 connected connection!
connected to: localhost:30000
exported 0 records

Comment by Bob McClellan Jr [ 10/Jan/12 ]

I also am having the same issue:

$ mongoexport --db forms_prod --collection form_templates --out autism_forms.json --query "{ study_ids :

{ '$in' : ["6"], '$nin' : ["2"] }

}"
connected to: 127.0.0.1
exported 0 records

I do a find inside of the mongo shell using the exact same query statement and it returns fine.

Generated at Thu Feb 08 03:05:28 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.