Sorting and Pagination

Efficiently navigate and organize large MongoDB collections with sorting and pagination.

Sorting Documents

Single Field Sort

Click any column header to sort by that field:

• First click: Ascending order
• Second click: Descending order
• Third click: Remove sort

Multi-Field Sort

Sort by multiple fields in order of priority:

1. Hold Shift and click column headers
2. First clicked column is primary sort
3. Additional columns are secondary sorts

Sort Syntax

When using the query editor, specify sort with MongoDB syntax:

// Sort by name ascending
{ "name": 1 }
 
// Sort by age descending, then name ascending
{ "age": -1, "name": 1 }

Pagination

Page Size

Choose how many documents to display per page:

• 25 - Quick loading, frequent paging
• 50 - Balanced (default)
• 100 - Fewer page loads
• Custom - Specify your own limit

Navigation Controls

Navigate through pages using:

• Next/Previous buttons
• Page number input
• Keyboard shortcuts (← / →)

Virtual Scrolling

For very large result sets, enable virtual scrolling:

1. Go to View Settings
2. Enable Virtual Scrolling
3. Scroll smoothly through thousands of documents

Performance Best Practices

1. Use indexes on sorted fields
2. Limit result sets with filters before sorting
3. Avoid sorting on large text fields
4. Use compound indexes for multi-field sorts

What's Next?

• Saved Queries
• Schema Management