So what this very much looks like is that you have already created collections in an existing database and now you are trying to access these with mongoose models. The problem is that mongoose uses some defaults which you may not be aware of, so the example you are showing from the shell is not … Read more
I solved the same problem just last night, this way: > db.test.aggregate({$group:{_id:{$gt:[“$field”, null]}, count:{$sum:1}}}) { “_id” : true, “count” : 2 } { “_id” : false, “count” : 2 } See http://docs.mongodb.org/manual/reference/bson-types/#bson-types-comparison-order for a full explanation of how this works. Added From comment section: To check if the value doesn’t exist or is null use … Read more
I also had a similar issue, and I was able to solve it by adding my white-listing my IP address under Clusters -> security -> IP Whitelist. Instead of clicking my current ip address, just search what’s my ip on google and paste that instead. I hope it works!
You can try below query. Static Imports import static org.springframework.data.mongodb.core.aggregation.Aggregation.*; import static org.springframework.data.mongodb.core.aggregation.ArrayOperators.Filter.filter; import static org.springframework.data.mongodb.core.aggregation.ComparisonOperators.Eq.valueOf; Code Aggregation aggregation = newAggregation( project().and(filter(“parts”) .as(“item”) .by(valueOf( “item.currentState”) .equalToValue( “Estimation Confirmed”))) .as(“parts”); ); List<outputType> results = mongoTemplate.aggregate(aggregation, inputType, outputType)
You can do this with mongo version higher 2.2 the query like this: db.coll.find({ ‘notes.title’: ‘Hello MongoDB’ }, {‘notes.$’: 1}); you can try with $elemMatch like Justin Jenkins
Use $ne — $not should be followed by the standard operator: An examples for $ne, which stands for not equal: use test switched to db test db.test.insert({author : ‘me’, post: “”}) db.test.insert({author : ‘you’, post: “how to query”}) db.test.find({‘post’: {$ne : “”}}) { “_id” : ObjectId(“4f68b1a7768972d396fe2268”), “author” : “you”, “post” : “how to query” } … Read more
The parameter in your Javascript is an array of 4 objects with one element each, in your PHP it’s an associative array (object) with 4 elements. This would represent your Javascript: $result = $c->aggregate(array( array( ‘$project’ => array( ‘day’ => array(‘$dayOfYear’ => ‘$executed’) ), ), array( ‘$group’ => array( ‘_id’ => array(‘day’ => ‘$day’), ‘n’ … Read more
The best way to do this is using the aggregation framework. You need to $group your documents by “user” and return the last document for each user using the $last accumulator operator but for this to work, you need a preliminary sorting stage using the $sort aggregation pipeline operator. To sort your documents, you need … Read more
You’re using mongoose 3.8.19. The latest version of mongoose is 4.1.9. I would start there: $ npm install –save –save-exact [email protected]
If you are using MongoDB 4.2, you can use aggregation operators in your update statement, like: .findOneAndUpdate({_id: day.id},[{$set:{present:{$eq:[false,”$present”]}}}]); That will set present to true if it is false, and to false if it is any other value.