Sort the Returned Documents
If the query bar displays the Sort option, you can specify the sort order of the returned documents.
Set the Sort Order
To set the sort order:
In the Query Bar, click Options.
Enter the
sort
document into the Sort field.To specify ascending order for a field, set the field to
1
in the sort document.To specify descending order for a field, set the field and
-1
in the sort documents.
Example
The following
sort
document sorts results first byyear
in descending order, and within each year, sort byname
in ascending order.{ year: -1, name: 1 } As you type, the Find button is disabled and the Sort label turns red until a valid query is entered.
Click Find to run the query and view the updated results.
Clear the Query
To clear the query bar and the results of the query, click Reset.
To Learn More
See the sort
entry in the
MongoDB Manual.
How Does the Compass Query Compare to MongoDB and SQL Queries?
$sort
corresponds to the ORDER BY ...
clause
in a SQL SELECT
statement.
Example
You have 3,235 articles. You would like to see a list of articles sorted alphabetically by headline.
- SQL
SELECT * FROM article ORDER BY headline ASC; - MongoDB Aggregation
db.article.aggregate( { $sort : { headline : 1 } } ); - Compass Sort Option
$sort : { headline : 1 }