How to sort in mongoose by specific order?

Question

I have Mongoose model:

const mongoose = require('mongoose')

const { Schema } = mongoose

const schema = new Schema({
    Name: { type: String }, 
    Category: { type: String },
    Price: { type: Number } 
})

module.exports = mongoose.model('Product', schema)

And I have to sort by Category field. Sort order is

['Clothes', 'Accessories', 'Footwears']

How cat I do it?

Does this answer your question? [How to sort in mongoose?](https://stackoverflow.com/questions/4299991/how-to-sort-in-mongoose) — turivishal, Aug 30 '20 at 13:03

score 1 · Answer 1 · answered Aug 30 '20 at 23:28

1

The MongoDB server doesn't offer any way to provide a custom sort function.

Javascript does, so you can get the results from the query as an array, and use a custom compare function with Array.sort

answered Aug 30 '20 at 23:28

Joe

25,000
3
22
44

Thank you about your reply. I solved it by creating new value as CategoryWeight. And when i save it, i set weight – Petr Vasilev Sep 04 '20 at 04:00

score 1 · Accepted Answer · answered Sep 04 '20 at 04:02

I solved it by adding weight of Category. Now my model is like this:

const schema = new Schema({
    Name: { type: String }, 
    Category: { type: String },
    CategoryWeight: { type: Number }, 
    Price: { type: Number } 
})

And I sorting like this:

const products = await Product.find().sort('-CategoryWeight')

How to sort in mongoose by specific order?

2 Answers2