Suppose the bottom left coordinates and the upper right coordinates are respectively [0, 0] and [100, 100]. From MongoDB 3.2 you can use the $slice operator to return a subset of an array which is what you want. db.collection.aggregate([ { “$match”: { “loc”: { “$geoWithin”: { “$box”: [ [0, 0], [100, 100] ] } }} … Read more
null is a valid _id value in MongoDB, so if you don’t want it used in new docs you must ensure that a null value is replaced with a new ObjectID in query: var query = {_id: plcy._id}; if (!query._id) { query._id = new mongoose.mongo.ObjectID(); } // the rest stays the same…
System Preferences >> Security & Privacy >> General >> [Unlock]>> Allow apps Downloaded from >> You will find an alert specifically for MongoDB Compass Previously there was an option to enable from “Anywhere”. Now it’s removed.
Updated: Seems $exists queries use index properly now based on these tickets $exists queries should use index & {$exists: false} will not use index Old Answer: No, there is no way to tell mongodb to use index for exists query. Indexing is completely related to data. Since $exists is only related to the keys (fields) … Read more
I created a spreadsheet to better illustrate the effect of Arbiter nodes in a Replica Set. It basically comes down to these points: With an RS of 2 data nodes, losing 1 server brings you below your voting minimum (which is “greater than N/2”). An arbiter solves this. With an RS of even numbered data … Read more
Sure it is, just clearing up the syntax but you basically had it: { “opened”: { “$elemMatch”: { “closed”: false, “$or”: [ { “openingEvening”: { “$lte”: currentTime }, “closingEvening”: { “$gte”: currentTime } }, { “openingMorning”: { “$lte”: currentTime }, “closingMorning”: { “$gte”: currentTime } } ] } } } And given a sample idea … Read more
Since the collection I was paging had duplicate values I had to create a compound index on ProductName and id. Create Compound Index db.ProductGuideItem.ensureIndex({ ProductName:1, _id:1}); This solved my problem. Reference: https://groups.google.com/d/msg/mongodb-user/3EZZIRJzW_A/oYH79npKZHkJ Assuming you have these values: {a:1, b:1} {a:2, b:1} {a:2, b:2} {a:2, b:3} {a:3, b:1} So you do this for the range based … Read more
Compare like with like The _id key in mongo is not (by default) a string – it is a mongo objectId. You need to compare to the same type to get a meaningful result: var ObjectId = require(‘mongodb’).ObjectID; var oid = new ObjectId(); db.things.find(_id: {$gt: oid}); Don’t read mongoexport files Mongo export files look like … Read more
So if anyone comes across this later, I was using the wrong option. What I was looking for is serverSelectionTimeoutMS
As documented on the docker hub page for that image (https://hub.docker.com/_/mongo/) you can use volumes: – ‘./data:/data/db’ Which will use the host path ./data