$addfield在特殊条件下的MongoDB

Question

当通过聚合获得数据时，我拥有这些数据。

    [{_id: 1,
      name:'Abraham',
      class:'V',
      question_answered:[{
      id:'quest1',
      answer:'A',
      score:10,
      question:{
        soal:'apa judul lagu?',
        correct_answer:'A',
        type_question:'Essay'
       }
      },
      {
      id:'quest2'
      answer:'C',
      score:null,
      question:{
        soal:'apa judul lagu B?',
        correct_answer:'B',
        type_question:'Essay'
       }
      },
      {
      id:'quest3'
      answer:'C',
      score:10,
      question:{
        soal:'apa judul lagu C?',
        correct_answer:'C',
        type_question:'essay_pg'
       }
      },
      ]
     }
    ]

现在我想添加名为formated_status_evaluation_essay和formated_status_evaluation_essay_option的条件加法字段，

条件：

IF(question_answer.question.type_question === 'Essay' && score !== null)
 formated_status_evaluation_essay = 'already scoring'
Elseif(question_answer.question.type_question === 'Essay' && score === null)
 formated_status_evaluation_essay = 'haven't scoring'
Elseif(question_answer.question.type_question === 'Essay' is not exists
 formated_status_evaluation_essay = 'No essay question'

formated_status_evaluation_essay_option与evaluation_essay具有相同的条件

Soo的预期产出就像

[{_id: 1,
  name:'Abraham',
  class:'V',
  question_answered:[.........]
  formated_status_evaluation_essay:'havent Scoring',
 formated_status_evaluation_essay_option:'Already Scoring'
 }
]

如何在mongodb中使用条件编写一个正确的附加字段来生成这样的输出？谢谢，以前我试过很多种方法，但还是没有得到答复。

我试过了，但似乎我把语法放错了。

      { 
        '$addFields': { 
          'formated_status_evaluation_essay': { 
               '$cond': [ 
                   {
                    '$and': [ 
                      {'$$question_answer.question.type_soal ': 
                      'essay'},
                      {'$$question_answer.nilai':{$ne:null}},
                      ]    
                    },
                   'already scoring', 
                   'havent scoring' 
               ] 
            } 
        } 
    }

Answer 1

db.collection.aggregate([
  {
    $set: {
      formated_status_evaluation_essay: {
        $cond: [
          {
            $and: [
              {
                $in: [
                  "Essay",
                  "$question_answered.question.type_question"
                ]
              },
              {
                $ne: [
                  "$question_answered.score",
                  null
                ]
              }
            ]
          },
          "already scoring",
          "havent scoring"
        ]
      }
    }
  }
])

蒙古操场