Skip to content

Instantly share code, notes, and snippets.

@amatai

amatai/List all fields in a collection

Created January 30, 2018 16:59
Show Gist options
  • Save amatai/4da50d4de0b5c681ec064dfe5e9cb8a6 to your computer and use it in GitHub Desktop.
Save amatai/4da50d4de0b5c681ec064dfe5e9cb8a6 to your computer and use it in GitHub Desktop.
Download ZIP
Mongo Tricks
Raw
List all fields in a collection
db.things.aggregate([{$project: {arrayofkeyvalue: {$objectToArray: "$$ROOT"}}}, {$unwind:"$arrayofkeyvalue"}, {$group:{_id:null, allkeys:{$addToSet:"$arrayofkeyvalue.k"}}}])
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment