I am new to mongodb, I have a collection of people and some of them have a value that I am interested in ("val"). For everyone who has that value, I would like to have a list of another value ("potential") without repeating. { "_id" : 001, "val" : true, "potential", 100} { "_id" :… Read More Mongodb, grouping values only once
I am new to mongodb, I have a collection of people and some of them have values that I am interested in. I would like to sum those values and get the number of people who had them. { "_id" : 001, "tot" : 10, "duration", 100} { "_id" : 002, "tot" : 20, "duration",… Read More Sum multiple fields with mongo db
insert many: [ { comments: [{foo:1}, {foo:1}, {foo:1}, {foo:1}] } { comments: [{foo:1}, {foo:1}] } { comments: [{foo:1}, {foo:1}, {foo:1}, {foo:1}, {foo:1}] } { title: ‘foo’ } { comments: [{foo:1}, {foo:1}, {foo:1}, {foo:1}, {foo:1}, {foo:1}] } ] I am trying to find a method to obtain the length of something from the document. I would… Read More mongodb: how to get the length of array with http method?
As the title says, I’m trying to remove items from a collection based on the lack of a specific key. Is there a nice way to do this? For example, in the set below, I want to delete all records that DO NOT have an "updated" key, such as the 2nd item which only has… Read More How to remove items from a Mongodb collection based on the lack of a specific key?
If you have this collection of objects: { "a": 10, "b": 20, "c": 30 } { "a": 11, "b": 20, "c": 31 } { "a": 10, "b": 20, "c": 31 } There is a way to get distinct values, for example, for field "a": [10, 11] There is also a way to get distinct values… Read More MongoDB query: keys and their distinct values (each key independently)?
my data here Does anyone who knows how to filter data and only keep those history_doc.data.objectId equals _id? I have tried so many methods but none of them works {‘history_doc.data.objectId’: {$eq: ‘$_id’}} {‘history_doc.data.objectId’: {$eq: {$toString: ‘$_id’}}} >Solution : You can use $expr and $eq with $toObjectId into aggregation query like this: .aggregate({ $match: { $expr:… Read More MongoDB filter when two fields equal
I’ve documents on my collection: {"date_time" : "2022-11-05 09:09:55", "dat1" : "TRUI", "cod" : "XC"} {"date_time" : "2022-11-21 09:09:55","dat1" : "TRQW","cod" : "KL"} {"date_time" : "2022-12-06 09:09:55","dat1" : "CBTR","cod" : "NM"} {"date_time" : "2022-12-18 09:09:55","dat1" : "METR","cod" : "XC"} So, I’d like to query my collection to get all documents with condition "cod" : "XC"… Read More MongoDB query range date with certain other key
{ "_id" : 1, "date" : ISODate("2019-06-23T00:00:00Z"), "tempsF" : [ 39.2, 53.6, 62.6 ] } { "_id" : 2, "date" : ISODate("2019-07-07T00:00:00Z"), "tempsF" : [ 57.2, 75.2, 51.8 ] } { "_id" : 3, "date" : ISODate("2019-10-30T00:00:00Z"), "tempsF" : [ 64.4, 42.8, 46.4 ] } Where does the “T00:00:00Z” in “ISODate” come from? to understand… Read More where does the t0000z come from?
I want to get user data of the last 6 months from the current date in MongoDB. I am filtering data by status than getting the array in response. I also want to apply another query on same based on date. I want to filter it once based on last 6 months then in another… Read More How to filter data of least 6 month in mongodb?
I am a beginner in node and mongoDb. I send a models from the application to node. const { users } = req.body; console.log(users); and when I print this I have this result. [ ‘{"id":"6389f4206f784a8e3d75cf10","email":"test5@test.com","password":"$2a$08$2cE5XFlShV0nBYS6JF4ckuRLcEvp75YuCazQLSyIZ6bKu5kev/dwS","verify":1,"invitationsToMe":["6390a3b8cb716fa4d67d82d6"],"invitationsFromMe":[],"friendsList":["638777339b32b61a57e5ab4b","638889b46b30846785db55df","638776e89b32b61a57e5ab43","638797306307ba909c43be22"],"username":"Przemek"}’, ‘{"id":"638797306307ba909c43be22","email":"test3@test.com","password":"$2a$08$wvtwkdwzKg.ZbEvWb2L5desAwoX0gUj723V/WgqiRRRFGl4AEltrm","verify":1,"invitationsToMe":["6390a3b8cb716fa4d67d82d6"],"invitationsFromMe":[],"friendsList":["638777339b32b61a57e5ab4b","638776e89b32b61a57e5ab43","638889b46b30846785db55df","6389f4206f784a8e3d75cf10"],"username":"Maciek"}’, ‘{"id":"638777339b32b61a57e5ab4b","email":"test2@test.com","password":"$2a$08$Zl8eJP8B2yYJaFMdH5045uQZnKB8JMmOMmMfCQXN/C0UfN1eMWdAi","verify":1,"invitationsToMe":["6390a3b8cb716fa4d67d82d6"],"invitationsFromMe":[],"friendsList":["638797306307ba909c43be22","638776e89b32b61a57e5ab43","638889b46b30846785db55df","6389f4206f784a8e3d75cf10"],"username":"Bartolinio"}’ ] Now i want to extract from each "id" number to save in array in mondoDb. I found… Read More Get all strings from array in mongoDb