How to sort a field with custom order?

[wedothebest_We_do_the_Best (WeDoTheBest4You)]

Hello,

Kindly refer to these resolved cases. It may help.

case 1 : using $switch
case 2: using if else block within $cond
case 3: using nested $cond

Case 1:

String Sort by Custom sort in MongoDB?

Hi @Kathiresan_S , You can use a switch case statement to have sortable values based on your logic: db.collection.aggregate([{ $addFields: { sortPriority: { $switch: { branches: [ { 'case': { $eq: [ '$priority', 'high' ] }, then: 3 }, { 'case': { $eq: [ '$priority', 'medium' ] }, then: 2 }, { 'case': { $eq: [ '$priority', 'low' ]…

Case 2:

MongoDB sort with a custom expression or function

Case 3:

How to sort data in Mongo in a custom order

Thanks
WeDoTheBest4You