需求为
将cdmRestcvr表下status = insertfailed的vehicle.bauMuster 字段截取前10位,会写vehicle.baumaster
db.cdmRestCvr.find({
status: 'insertfailed'
}).forEach(function(user) {
user.tempbauMuster = user.vehicle.bauMuster.substr(0, 10);
print(user._id, user.tempbauMuster);
db.cdmRestCvr.update({
"_id": user._id
}, {
$set: {
"vehicle.bauMuster": user.tempbauMuster
}
});
})