MongoDB - Updating datatype in nested array for String to Number not working

Question

I tried to update the MongoDB nested arrays data types, It's updated NaN value. Could you please help me out, anyone. Thanks

MongoDB data:

This is my MongoDB data productqtydetails collection.

[{
    "_id" : ObjectId("5d31567ea23d120f087a9ab1"),
    "productId" : ObjectId("5d31567ea23d120f087a9aaf"),
    "sizes" : [ 
        {
            "name" : "4",
            "qty" : 3.0,
            "price" : "1500.0"
        }, 
        {
            "name" : "5",
            "qty" : 6.0,
            "price" : "1600.0"
        }, 
        {
            "name" : "6",
            "qty" : 7.0,
            "price" : "1700.0"
        }
    ]
}
....
]

Mongo Shell Script:

db.productqtydetails.update({
    _id : ObjectId("5d31567ea23d120f087a9ab1")
    },
{
    $set: {"sizes.$[].price": parseFloat("$sizes.$[].price") //Here I used parseInt(), NumberInt also
}
});

Updated MongoDB data:

after ran the script. i got the price : NaN it is updated.

[{
    "_id" : ObjectId("5d31567ea23d120f087a9ab1"),
    "productId" : ObjectId("5d31567ea23d120f087a9aaf"),
    "sizes" : [ 
        {
            "name" : "4",
            "qty" : 3.0,
            "price" : NaN
        }, 
        {
            "name" : "5",
            "qty" : 6.0,
            "price" : NaN
        }, 
        {
            "name" : "6",
            "qty" : 7.0,
            "price" : NaN //need to update "price" : 1700.0
        }
    ]
}
...
]

@Anban I got the error Error: Input is not a valid Decimal128 value. — Senthil
– Senthil, Commented Aug 28, 2019 at 14:34

Rajat Goel · Accepted Answer · 2019-08-28 10:37:23Z

1

Firstly, parseFloat is a javascript function and not a MongoDB operator. Means you can use it in a script but not in a MongoDB query/command.

Secondly, an update command can not have self-reference (means you can not update a field in a document using the same/different field of the very same document).

In short, you can not do this in a single query. You need two queries, first to fetch and second to update.

db.productqtydetails.find({_id : ObjectId("5d31567ea23d120f087a9ab1")}).forEach(function(data) {
    var sizes = data.sizes;
    for(var i = 0; i < sizes.length; i++) {
        sizes[i]["price"] = parseFloat(sizes[i]["price"]);
    }

    db.productqtydetails.update(
        {"_id": data._id},
        {"$set": {"sizes": sizes}}
    );
})

answered Aug 28, 2019 at 10:37

Rajat Goel

2,3051 gold badge20 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MongoDB - Updating datatype in nested array for String to Number not working

MongoDB data:

Mongo Shell Script:

Updated MongoDB data:

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

MongoDB data:

Mongo Shell Script:

Updated MongoDB data:

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related