Get keys of a document in MongoDB Document

Question

Is there any way to get the list of keys of a particular document in MongoDB other than iterate through the document?

i.e I want to get the keys for the document returned by

db.users.find({username:'xyz@abc.com})

Are there any inline commands.If not,can anybody give an idea on how to do?

see http://stackoverflow.com/a/26063468/288875 – Andre Holzner Jan 16 '15 at 22:17 — Andre Holzner, Jan 16 '15 at 22:17

score 5 · Answer 1 · answered Oct 27 '16 at 17:53

5

Object.keys(db.users.findOne({username:'xyz@abc.com'}))

will return a list of all the keys of a particular document.

answered Oct 27 '16 at 17:53

akki

2,021
1
24
35

score 3 · Answer 2 · answered Dec 09 '13 at 20:45

3

I know I am a little bit late to the party here, but you can do this in the mongo shell by typing:

var entry = db["users"].findOne({username:'xyz@abc.com});
for (var key in entry) { print(key); }

The important piece is findOne, this way you grab the fields of the first document rather than a list of the matching documents. Then you can simply loop through and print the keys.

answered Dec 09 '13 at 20:45

mgoldwasser

14,558
15
79
103

+1 for noting that the important piece is the `fineOne`. Using just `find` will return a lot of stuff you aren't really interested in. – Francis Bartkowiak Jun 30 '21 at 12:37

score 1 · Answer 3 · answered Jun 19 '12 at 19:24

1

No, there's no such command. You have to fetch the document and process it in the app.

answered Jun 19 '12 at 19:24

Sergio Tulentsev

226,338
43
373
367

Get keys of a document in MongoDB Document

3 Answers3