How to change the type of a field?

by

The only way to change the $type of the data is to perform an update on the data where the data has the correct type.

In this case, it looks like you’re trying to change the $type from 1 (double) to 2 (string).

So simply load the document from the DB, perform the cast (new String(x)) and then save the document again.

If you need to do this programmatically and entirely from the shell, you can use the find(...).forEach(function(x) {}) syntax.

In response to the second comment below. Change the field bad from a number to a string in collection foo.

db.foo.find( { 'bad' : { $type : 1 } } ).forEach( function (x) {   
  x.bad = new String(x.bad); // convert field to string
  db.foo.save(x);
});

More Related Contents:

  1. How do I perform the SQL Join equivalent in MongoDB?
  2. How to remove array element in mongodb?
  3. MongoDB: How to update multiple documents with a single command?
  4. In mongoDb, how do you remove an array element by its index?
  5. How do I partially update an object in MongoDB so the new object will overlay / merge with the existing one
  6. Ways to implement data versioning in MongoDB
  7. Mongodb update deeply nested subdocument
  8. How do I seed a mongo database using docker-compose?
  9. MongoDB: Unique index on array element’s property
  10. Select Max() with “group by” in mongodb
  11. MongoDB – Update or Insert object in array
  12. How to get back the Original document back after aggregation
  13. Updating the path ‘x’ would create a conflict at ‘x’
  14. How can I update multiple documents in mongoose?
  15. MongoDB update with condition
  16. mongodb get distinct records
  17. How can I sort into that nulls are last ordered in mongodb?
  18. Changing MongoDB data store directory
  19. What does it mean to fit “working set” into RAM for MongoDB?
  20. Mongoose limit/offset and count query
  21. $skip and $limit in aggregation framework
  22. Read-only file system when attempting mkdir /data/db on Mac [closed]
  23. mongodb move documents from one collection to another collection
  24. How does the order of compound indexes matter in MongoDB performance-wise?
  25. Multiply field by value in Mongodb
  26. count array occurrences across all documents with mongo
  27. Group by sum mongodb [duplicate]
  28. MongoDB on Ubuntu won’t start as a service, nothing in the log
  29. Mongodb concat int and string
  30. Aggregation with update in mongoDB

Leave a Comment