Breaking News: Grepper is joining You.com. Read the official announcement!

set with conditions in mongodb

Breakable Bison answered on October 20, 2021 Popularity 8/10 Helpfulness 4/10

answer set with conditions in mongodb

set with conditions in mongodb

Comment

db.collectionname.aggregate(
    [
        {
            $set: {                   //Compute the new value
                'ResultField': {
                    $cond: {
                        if: {
                            $lt: ['$ScoreField', 40]
                        },
                        then: "Fail",
                        else: "Pass"
                    }
                }
            }
        },
        {
            $out: 'collectionname'    //Update the records in collection
        }
    ]
)

Popularity 8/10 Helpfulness 4/10 Language whatever

Source: stackoverflow.com

Tags: mongodb set whatever

Link to this answer
Share Copy Link