zjffun blog

MongoDB Sort By in

更新于 写于 mongodb

mongoose - Does MongoDB's $in clause guarantee order - Stack Overflow

js
var order = ["David", "Charlie", "Tess"];

var query = [
  { $match: { name: { $in: order } } },
  { $addFields: { __order: { $indexOfArray: [order, "$name"] } } },
  { $sort: { __order: 1 } },
];

var result = db.users.aggregate(query);