Mongo查询数据获取条件问题

Question

示例输入

[{
    leadId : 20,
    status: in-progress,
    date: '07-03-2022',
    score:{
        create: 30,
        start: 45,
        in-progress: 90
    }
},
{
    leadId : 21,
    status: start,
    date: '06-03-2022',
    score:{
        create: 30,
        start: 45,
        in-progress: 90
    }
},
{
    leadId : 22,
    status: start,
    date: '05-03-2022',
    score:{
        create: 30,
        start: 45,
        in-progress: 78
    }
},
{
    leadId : 23,
    status: in-progress,
    date: '02-03-2022',
    score:{
        create: 30,
        start: 12,
        in-progress: 61
    }
}]

输出：

[{
    leadId : 20,
    status: in-progress,
    date: '07-03-2022',
    score:{
        create: 30,
        start: 45,
        in-progress: 90
    }
},
{
    leadId : 23,
    status: in-progress,
    date: '02-03-2022',
    score:{
        create: 30,
        start: 12,
        in-progress: 61
    }
}]

如果分数列中的当前状态值大于 60，我需要获取记录。

注意状态列值是动态更新的

Answer 1

这个问题不太清楚，但我想你需要这样的东西：

  db.collection.find({
       "score.in-progress": {
     $gt: 60
    },
      "status": "in-progress"
  })

afcoursecompoundindex on {score_in_progress:1,status:1} or {status:1,score_in_progress:1} is very likely be create

游乐场