I'd like to take weekly, hourly report of data based on date field from mongodb, for doing so, have tried to add new field called "difference" using addFields stage before the match stage and then try to use that "difference"…
I've been trying to extract one record each 1 hour from a collection with 1 record each 10 seconds on the datetime (Date). The document is like this: datetime: 2021-11-26T15:08:20.000+00:00 owner_id: "INTERNAL" motor_id: 24 The datetime document field is Date()…
Below is a block from my aggregate query, { $addFields: { destinations: { $filter: { input: "$destinations", cond: { $and: [ { $or: [ { "$$this.reported_at": { $exists: false } }, { "$$this.reported_at": { $eq: null } } ], },…
I have the following project: { '$project': { '_id': 1, 'applicationIds': { 'type': 'linux', 'refId': '$applicationIds' }, 'configurationIds': { 'type': 'linux', 'refId': '$configurationIds' } } } As long as there is at least one record in $configurationIds I will get…
I want to find the max and min values of the myUpdateTime field. It's a timestamp but stored as a string. "myUpdateTime": "2021-11-08T17:42:30.650Z",
I have a MongoDB collections as: Collection: [ { "_id": ObjectId("64390a7196f544082a671469"), "name": "Sydney", "issues": [ {"vol": "2", "num": "1", "freq": 5}, {"vol": "1", "num": "2", "freq": 7} ] }, { "_id": ObjectId("64390a8796f544082a67146a"), "name": "Canton", "issues": [ {"vol": "2", "num": "2",…
I have the below MongoDB json document { "_id" : ObjectId("605c8351e874ab0012081b7d"), "fw8_pk" : NumberLong(604063), "customer_name" : "Testing_9.6", "customer_type" : "NP", "customer_status" : "A", "created_by" : NumberLong(0), "creation_date" : NumberLong(1616675665396), "last_updated_by" : NumberLong(0), "last_updated_date" : NumberLong(1681210340164), "last_sync_ts" : NumberLong(0), "subscription" :…
This is a followup question to Draft an aggregate to group based on a nested attribute with lookup There are these two collections as listed below orders: [ { "_id": "64355c928dcce8cdf4b9c7d2", "destinations": [ { "ship_to_id": "64355c92af10d37993473e12", // mongoose id from…
How to delete the strings before the first occurrence, and after the last occurrence of the delimiter? The delimiter is an underscore "_". Sample data is: [ { "originalValue": "DELETERANDOMVALUE_Keep_This_Words_DELETERANDOMVALUE" } ] The expected result should be: [ { "cleanedValue":…
I am new to MongoDB. I have a VIEW created on a collection, I need to make a modification to this VIEW. Say we have a collection CollectionName. It has an array field aArray. This arrays has 2 fields, arrayField1…