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?

--query "{'xid':{'$ne':0}}" double quotes outside and single quotes inside stackoverflow.com/questions/21456714/… — Mohammed Ashiq
– Mohammed Ashiq, Commented Dec 27, 2016 at 7:21

Darshan J · Accepted Answer · 2015-06-19 21:34:09Z

21

you can use below commands

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

answered Jun 19, 2015 at 21:34

Darshan J

3512 silver badges5 bronze badges

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

Comments

Jinxcat · Accepted Answer · 2014-01-31 08:11:46Z

13

You can use the following as your query:

{ $and: [
    {xid: {$exists:true}},
    {xid:{$gt:0}}
    ]  
}

$and "performs a logical AND operation on an array of two or more expressions (e.g. , , etc.) and selects the documents that satisfy all the expressions in the array."

$exists checks if the specific field is present in the document.

Also, as it is being pointed out by Vijay, in your description you mention you want xid > 0. You shouldn't be using $ne (not equal), but $gt (greater than).

edited Jan 31, 2014 at 8:11

answered Jan 30, 2014 at 14:27

Jinxcat

5841 gold badge3 silver badges17 bronze badges

Comments

vijin selvaraj · Accepted Answer · 2018-01-10 12:28:22Z

5

mongoexport --db db_name --collection collection_name --query "{'Name':'Vijil'}" --out file_name.json

answered Jan 10, 2018 at 12:28

vijin selvaraj

1241 silver badge6 bronze badges

1 Comment

Yahya Hussein Over a year ago

add some explanation

Sudhanshu Gaur · Accepted Answer · 2018-10-16 11:11:13Z

5

Remember as of 3.0.6 --csv tag is not supported, now in order to use that use --type=csv

Below is the query which takes MongoExport on the database db_name and collection collection_name, Remember to specify field names also(which fields you want to add in your csv file).

sudo mongoexport -d db_name -c collection_name --type=csv --query='{field1:{$gt:2}}' -f "field1,field2" --sort='{field1:-1}' -u 'username' -p 'passwd' --authenticationDatabase=admin --out dir/file.csv

answered Oct 16, 2018 at 11:11

Sudhanshu Gaur

7,69211 gold badges55 silver badges105 bronze badges

Comments

Jinxcat · Accepted Answer · 2014-01-31 08:14:39Z

4

You can change your query to

--query {id: {$exists : true}, xid: {$gt : 0}}

This above query will return only those documents that have id field and have value of xid > 0. So if there is any document that have only id field not xid, those documents will not be returned.

edited Jan 31, 2014 at 8:14

Jinxcat

5841 gold badge3 silver badges17 bronze badges

answered Jan 30, 2014 at 18:09

Vicky

8899 silver badges18 bronze badges

Comments

Pang · Accepted Answer · 2021-05-31 07:06:24Z

1

From the document given above, it seems it is an array of documents, but you are accessing the document without . notation. Seems you are accessing the document wrongly.

Should be something like '{"key.xid":{"$ne":0}}'

edited May 31, 2021 at 7:06

Pang

10.2k146 gold badges87 silver badges126 bronze badges

answered Jan 30, 2014 at 13:47

arunb2w

1,1961 gold badge11 silver badges29 bronze badges

Collectives™ on Stack Overflow

MongoDB mongoexport query

6 Answers 6

Comments

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related