MongoDB - How do I change the type of an string found in an array nested within a subdocument

Question

I'm trying to change a type string to an Integer. The following code selects the right element when simply searching and the code works perfectly for string elements at the top.

db.providers.find({'assignments.assignment' : 
    {$elemMatch :
        {
            as_total_hours : 
                {$exists : true}}}}).forEach( function(obj) { 
                    obj.as_total_hours = parseInt(obj.as_total_hours); 
                    db.providers.save(obj); 
                })

Here is a sample of the document.

"dev_active_interviews" : 0,
"assignments" : {
    "assignment" : [ 
        {
            "as_rate" : "$3.89",
            "as_from" : "05/2011",
            "as_to"   : "Present",
            "as_total_hours " : "16"
        },
        {
            "as_rate" : "$2.22",
            "as_from" : "11/2010",
            "as_to"   : "Past",
            "as_total_hours" : "200"
        }
     ]
  }

jimoleary · Accepted Answer · 2013-06-08 20:41:02Z

3

Your code is assuming that the find returns the embedded assignment objects rather than the object.

Change :

obj.as_total_hours = parseInt(obj.as_total_hours);
db.providers.save(obj);

to

obj.assignments.assignment.forEach(function(obj) {
    obj.as_total_hours = parseInt(obj.as_total_hours);
})
db.providers.save(obj);

You could also change the {$exists:true} to {$type: 2} (or combine them) so that the query only finds strings.

answered Jun 8, 2013 at 20:41

jimoleary

1,65513 silver badges11 bronze badges

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

Collectives™ on Stack Overflow

MongoDB - How do I change the type of an string found in an array nested within a subdocument

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related