Here see this Collection here have a record with createdAt with 14Feb and one with 16Feb, Now querying an aggregation on the collection such as I want to add an document of 15Feb as it was missing in collection with…
I have a document like below { "name" :{ "English": "AA", "Bengali": "BB", "Gujarati": "CC", "Hindi": "DD"} } can I filter it based on the keys e.g. need to filter only on 'English' and 'Hindi' so the output should be…
I have a sample data like this : db.contact.insert( [ { _id: 1, name: 'John legend',age: 35}, { _id: 2, name: 'michael Ava',age: 40}, { _id: 3, name: 'Tom holand',age: 20}, { _id: 4, name: 'Frido pex',age: 25}, { _id:…
I try to convert a postgreSQL query (from the nextjs dashboard tutorial from vercel) to a mongodb query using aggregate and $lookup. I know how to aggregate multiple collections and filter for one parameter. And how to query one collection…
I have an aggregation pipeline in which I'm trying to find the unique values within an array property and also the number of instances of each value within each document's array. I arrive at a stage where the documents look…
time: { $currentDate: { $type: "timestamp" } } }); It's not working for insert() can you help me, anyone?
I have a collection of documents as follows: { "id": ..., "key": 47 }, { "id": ..., "key": 12 } I want to aggregate the whole collection to a single string, by concatenating the keys, delimited by |. So here,…
I want to slice array in document according to slicingIndex key available in the same document and push into an array. [ { slicingIndex: [0, 4, 7, 10], array: [ { name: 1 }, { name: 2 }, { name:…
I have a collection of documents that each contain arrays. the output i want is the unwinded array elements filtered down by a certain criteria. i can do this by doing: db.collection.aggregate([ { $unwind: "$myArrayField" }, { $match: { "myArrayField.myCriteriaField":…
I have a collection made like this [ {timestamp: xxx, type:'start'}, {timestamp: xxx, type:'log'}, {timestamp: xxx, type:'log'}, {timestamp: xxx, type:'log'}, {timestamp: xxx, type:'start'}, {timestamp: xxx, type:'log'}, {timestamp: xxx, type:'log'} ] how do I aggregate the start event and the log…