mongo update query not working for older version

Question

Below query works fine for mongo version 4.2, but when I run the same query on the older version it is an error -"The dollar ($) prefixed field $concat in GUID.$concat is not valid for storage".

db.getCollection('xxxx').update(
    { "SHARE": false },
    [{ 
        "$set": { 
            "GUID": { 
                "$concat": [
                    { $toString: "$ID" }, 
                    { $toString: "$DATE" }
                ] 
            } 
        } 
    }],
    { 
        upsert: false,
        multi: true 
    }
)

Is there any way to modify the above query in older mongo version.

yes this is from 4.2, you can not use in older version. update-documents-with-aggregation-pipeline — turivishal
– turivishal, Commented Aug 11, 2020 at 14:00
can that help your case: stackoverflow.com/questions/52326901/…? — gmolaire
– gmolaire, Commented Aug 11, 2020 at 16:36
With older versions (pre MongoDB 4.2) you can update using two operations - first the aggregation (using $concat, etc.) and then an update. — prasad_
– prasad_, Commented Aug 12, 2020 at 1:41
Your update query will update documents which are the result of the aggregation. Check your aggregation result, first and then update. — prasad_
– prasad_, Commented Aug 12, 2020 at 7:42
@prasad_ Thanks for the help. below query works for me. db.getCollection('xxxx').aggregate([ {$addFields: { GUID: { $concat: [ {$toString:"$ID"} ] }}} ]).forEach ( function(x) { db.getCollection('xxxx').update({"_id":x._id},{$set:{GUID:x.GUID}},{multi:true}); //print((x._id.toString())) } ) — Naik
– Naik, Commented Aug 12, 2020 at 8:43

Naik · Accepted Answer · 2020-08-12 08:46:55Z

0

Below query works for me,

db.getCollection('xxxx').aggregate([ {$addFields: { GUID: { $concat: [ {$toString:"$ID"} ] }}} ]).forEach ( function(x) { db.getCollection('xxxx').update({"_id":x._id},{$set:{GUID:x.GUID}},{multi:true}); //print((x._id.toString())) } )

answered Aug 12, 2020 at 8:46

Naik

215 bronze badges

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

Collectives™ on Stack Overflow

mongo update query not working for older version

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related