MongoDB mongoexport query

Question

I have a collection of the following form in MongoDB. As you can see some documends have two members "id" and "xid" and some have only 1 "id" (aside from the Object _id)

[     {         "id" : 1,     },      {         "id" : 2,     },      {        "id" : 3        "xid": 300     } ] 

I want to create a mongoexport statement that exports to a csv only documents with id's AND xid's with the value of xid > 0

I currently have the following command:

mongoexport -h host -u user -p pass --db database --collection collections --csv --fields id,xid --query '{"xid":{"$ne":0}}' --out rec.csv 

However this also exports documents that have an id without an xid. So i get something like

xid, id 12, 3 ,4 14, 5 ,3 ,2 12, 5 

etc.

Is there a way to export documents that only have both id and xid?

Answer 1

you can use below commands

mongoexport -d database_name -c collection_name --csv --query { id:{$exist:true},xid:{$gt:0}}