Get a document in MongoDB without specifying collection

by

Yes, but not in a scalable way (since you must query each collection). If you have 2 or 3 collections, this might be ok, but… you probably should review your design to figure out why you’re doing this. Why are you, by the way?

  1. You get a list of all of the collections in the database.
  2. You loop through them, and query based on _id

Sample shell code:

db.test1.save({});
db.test2.save({});  
db.test3.save({});
db.test4.save({});
db.test5.save({}); 
db.test6.save({});

db.test2.findOne(); // gives: { "_id" : ObjectId("4f62635623809b75e6b8853c") }

db.getCollectionNames().forEach(function(collName) {
   var doc = db.getCollection(collName).findOne({"_id" : ObjectId("4f62635623809b75e6b8853c")});
   if(doc != null) print(doc._id + " was found in " + collName); 
});

gives: 4f62635623809b75e6b8853c was found in test2

More Related Contents:

  1. Possibility of duplicate Mongo ObjectId’s being generated in two different collections?
  2. Where does mongodb stand in the CAP theorem?
  3. How do you query for “is not null” in Mongo?
  4. How to stop insertion of Duplicate documents in a mongodb collection
  5. Is mongodb running?
  6. Does MongoDB support floating point types?
  7. MongoDB normalization, foreign key and joining
  8. Update field in exact element array in MongoDB
  9. MongoDB: How to update multiple documents with a single command?
  10. Store images in a MongoDB database
  11. Add new field to every document in a MongoDB collection
  12. Querying internal array size in MongoDB
  13. How can I run MongoDB as a Windows service?
  14. MongoDB vs. Cassandra [closed]
  15. Find duplicate records in MongoDB
  16. Best practice to maintain a mgo session
  17. How do you rename a MongoDB database?
  18. How do I do a “NOT IN” query in Mongo?
  19. How to enforce foreign keys in NoSql databases (MongoDB)?
  20. NoSQL (MongoDB) vs Lucene (or Solr) as your database [closed]
  21. MongoDB update with condition
  22. MongoDB lookup when foreign field is an array of objects
  23. Mongodb: Failed to connect to 127.0.0.1:27017, reason: errno:10061
  24. MongoDB nested array query
  25. Filtering embedded documents in MongoDB
  26. Mongodb aggregation $group, restrict length of array
  27. MongoDB/NoSQL: Keeping Document Change History
  28. MongoDB Single Document size limit is 16MB
  29. Unique IDs with mongodb
  30. How to return only value of a field in mongodb

Leave a Comment