How to sort data using MongoDB Compass

mongodb mongodb-compass
Aabhas picture Aabhas · Jun 20, 2017 · Viewed 23.4k times · Source

I'm currently trying to use MongoDB Compass to query my collection. However, I seem to be only able to filter the data.

Is there any way for me to sort the data as well? I would like to sort my data in ascending order using one of my data fields.

If MongoDB Compass isn't the best way to order a collection, what other GUI could I use?

Answer

Stennie picture Stennie · Jun 26, 2017

Using MongoDB Compass 1.7 or newer, you can sort (and project, skip, or limit) results by choosing the Documents tab and expanding the Options.

enter image description here

To sort in ascending order by a field myField, use { myField:1 }. Any of the usual cursor sort() options can be provided, including ordering results by multiple fields.

Note: options like sort and skip are not available in the default Schema tab because this view uses sampling to find a random set of documents, as opposed to the Documents view which displays a specific query result.

Related questions

Could not connect to MongoDB on the provided host and port

I just want to try MongoDB Compass GUI for MongoDB, but when I try to connect using local host port: 27017 I get this error: Could not connect to MongoDB on the provided host and port I followed these instructions on …

Read More
Searching by ObjectId on Mongo Compass

How does one use Mongo Compass and search by ObjectID? I've been searching for the documentation for this but haven't been successful with anything. I have tried: { "_id" : "58f8085dc1840e050034d98f" } { "$oid" : "58f8085dc1840e050034d98f" } { "id" : "58…

Read More
Windows MongoDB - Installed Compass but can't find Compass within system

I ran the MongoDB Community Version Download Setup with the GUI for Mongo - Compass checked. No problems with the installation and the setup was successfully completed. However after the setup I couldn't find Compass installed anywhere in my system. …

Read More