I have the below dbData wherein in the contracts collection, there is an attribute called via which is an array that holds the mongoose ids of depot entries. db={ "contracts": [ { "_id": ObjectId("630c9e23fb146c4b3b801b9e"), "detention_id": [], "route_exclude": false, "trip_count": null,…
{ "id": 1, "holdDetails": [ { "holdDescription": "COVERT_LOCK", "holdStatus": "CREATED" }, { "holdDescription": "ALPH_LOCK", "holdStatus": "RESOLVED" } ] }, { "id": 2, "holdDetails": [ { "holdDescription": "ALPHA_LOCK", "holdStatus": "RESOLVED" }, { "holdDescription": "BETA_LOCK", "holdStatus": "RESOLVED" } ] }, { "id":…
I'm learning mongoDB queries and have a problem given my collection looks like: "filename": "myfile.png", "updatedCoordinates": [ { "xmin": 537.640869140625, "xmax": 1049.36376953125, "ymin": 204.90736389160156, "ymax": 714.813720703125, "label": "LABEL_0", "status": "UNCHANGED" }, { "xmin": 76.68355560302734, "xmax": 544.8860473632812, "ymin": 151.90313720703125, "ymax": 807.1371459960938,…
I have the following data structure: { "_id": ObjectId("630bd746956bba0f6f0ba448"), "a": [ { "b": [ [ [ { "c": "aaa" } ] ] ] } ], } How can I filter all documents with the value aaa for their nested c…
I have set of documents in my mongoDB collection. I am looking to get datewise aggregate count of document if date range is more than a day and hourly aggregate count for same column if date query is for single…
I have an array of mongoDB collection - [ { "_id": "630499244683ed43d56edd06", "userId": "630499234683ed43d56edd05", "isPaid": "true" }, { "_id": "6304c19bda84477b41b4bbfa", "userId": "630499234683ed43d56edd05", "isPaid": "true" }, { "_id": "6304c1b5da84477b41b4bbfb", "userId": "630499234683ed43d56edd05", "isPaid": "true" }, { "_id": "6304c1cbda84477b41b4bbfc", "userId": "630499234683ed43d56edd05", "isPaid": "true"…
I have a list of collection like the following in mongodb { _id: ObjectId("6087feeef467a4320883daf3"), name: 'group 1', admins: ['adam', 'ken'] } { _id: ObjectId("2087feeef467a4320883daf3"), name: 'group 2', admins: ['rebecca'] } { _id: ObjectId("9987feeef467a4320883daf3"), name: 'group 3', admins: [] } I…
I have a ranks collection with a permissions field which are bitwise operators: [ { "_id": "xxxx", "name": "Rank 1", "permissions": 1 }, { "_id": "xxxxxxxxx", "name": "Rank 2", "permissions": 2 } ] Example users: [ { "_id":"1234", "ranks":[ "xxxx",…
Let's say my documents look like this: [ { name: "Example 1", year: "2012" }, { name: "Example 2", year: "2012" }, { name: "Example 3", year: "2013" }, { name: "Example 4", year: "2014" } ] Using an aggregation,…
[ { _id:1 value: "8 Aug 2022, 1:13 PM" }, { _id:2 value: "15 Aug 2022, 1:13 PM" } ] Want to convert the above documents with the value field as an ISO Date I was splitting the first part…