[MONGO] find sort by multiple columns - fourslickz/notes GitHub Wiki

• 1: ascending
• -1: descending

---

const mongoose = require('mongoose');

mongoose.connect('mongodb://localhost:27017/mydatabase', { useNewUrlParser: true, useUnifiedTopology: true });

const userSchema = new mongoose.Schema({
  name: String,
  age: Number,
  registrationDate: Date
});

const User = mongoose.model('User', userSchema);

// Function to find users and sort by multiple columns
async function findAndSortUsers() {
  try {
    const users = await User.find({}).sort({ age: 1, registrationDate: -1 });
    console.log('Found users:', users);
  } catch (err) {
    console.error('Error fetching users:', err);
  }
}

// Example usage
findAndSortUsers();