mongoDB 过滤、排序和排名结果

发布于07月25日

我有一个这样的Collection

{
 id: 1,
 category: "food",
 score: 20
}
{
 id: 2,
 category: "drink",
 score: 19
}
{
 id: 3,
 category: "food",
 score: 50
}
{
 id: 4,
 category: "food",
 score: 30
}

顺便说一句，id不是唯一的.

所以有可能

{id: 1, category: "food"}
{id: 1, category: "drink"}

但不是

{id: 1, category: "food"}
{id: 1, category: "food"}

here's what I want to do

find all category == "food"
-> it will give id: 1, 3, 4
// I can add some other filter here before sort happen
// like id less than 100

sort them by score
-> it will give id: 3, 4, 1 // highest score must be the first entry

then what is the rank of id: [4, 1]
-> it should give me {id: 4, rank: 2}, {id: 1, rank: 3}

我怎样才能做到这一点？

推荐答案

  db.collection.aggregate([
  {
    "$match": { //Filter conditions
      "category": "food"
    }
  },
  {
    "$sort": {//Sorting
      "score": -1
    }
  },
  {
    "$group": { //Group by null to get array index
      "_id": "null",
      "data": {
        "$push": "$$ROOT",
        
      }
    }
  },
  {
    "$unwind": { //Unwind and get index
      path: "$data",
      "includeArrayIndex": "index"
    }
  },
  {
    "$match": {
      "data.id": { //Filter require ids
        $in: [
          3,
          4
        ]
      }
    }
  }
])

Sample