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…
Scenario Example Mongo DB documents Doc 1 { _id 123 Customer: customer A State: TX City: Houston checksum: 1111 IsBundlled: } Doc 2 { _id 1234 Customer: customer B State: TX City: Houston checksum: 1111 IsBundlled: } Doc 3 {…
Here is the sample document { "pId":12345, "charges": { "key1": "10.0,11.0,12.0,13.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0", "key2": "22.5%,12.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%", "key3": "271.95,371.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,394.45,271.95,394.45", ... } } Charge keys are dynamic. I wanted to fetch the requested index values from charges Ex: input index is (1, 2) the expected…
I have data on a MongoDB collection stored in documents like these: { "_id": "657c54befca2b6a2cdd935ba", "data": { "name": "Bob", "surname": "xxx", "age": "20", }, "header": { "data": "1702646974156", } "_class": "Prova" } { "_id": "657c54befca2b6a2cdd935bb", "data": { "name": "Tom", "surname":…
Supposed I have the following data: Time Submitted 1 True 2 True 3 True 4 False 5 False 6 False My goal is to get either the the oldest unsubmitted OR the newest submitted. This is for loading user timesheets,…