I have this in [ { "date": "2022-12-03T12:16:52.403Z", "configs": [ { "name": "Shubham", "values": [ { "text": "172cm", "type": "Height", }, { "text": "80kg", "type": "Weight", }, { "text": "male", "type": "Gender", }, ], } ] }, {....},{....} ] Want…
My collection Looks like this: [ { "_id": { "$oid": "638ecf5247cf747bdd862bfb" }, "title": "This is title one" }, { "_id": { "$oid": "638ecf5247cf747bdd862bfb" }, "title": null }, { "_id": { "$oid": "638ecf5247cf747bdd862bfb" }, "title": "This is title three" } ]…
I have a mongo document that looks like the below JSON object. What I'm trying to do, using the mongoDb Query builder, is return all books from user 1 that are read: false. For example: var query = new Query();…
Below is array of documents with collection_date. For a given collection date, I wanted to identify start date and end date using MongoDB aggregation pipeline. [ { "collection_date": 2022-12-01, "created_timestamp": 1668177586955, "created_by": "SYSTEM", "updated_timestamp": 1668177586955, "updated_by": "SYSTEM" } ] Let's…
I have this data in MongoDB. { _id: "abc*hello*today*123", "value": 123 }, { _id: "abc*hello*today*999", "value": 999 }, { _id: "xyz*hello*tomorrow*123", "value": 123 } What I want is to group by the first part before "*{number}". This is what I…
I have a posts collection and I want to return the latest posts and featured posts with 1 query. post document sample { "title":"Hello World", "author":"Bob Paul", "featured":True, "published":True, "created_at":"2019-01-15 10:27:16.354Z" } This is what I want returned: { "latest":…
I have two collections Post (belongs to posts database) and User (belongs to account database). My requirements to do join on these two collection. But I am unable to reproduce my requirements. I am expecting joins on two collections.
Lets say I am having two collections named CollectionA and CollectionB, Both collection have different fields. CollectionA will have multiple documents with Same field, CollectionB contain only one document Example CollectionA { "UniqeId" :1, "Hobbies" : "Eating" }, { "UniqeId"…
This question is slightly different from others since I need to get the whole documents and not just specific fields. I need to filter documents(all of the document, not just specific fields), according to the last elements value of a…
Consider I have the following collection: [ { "total": 48.0, "status": "CO" }, { "total": 11.0, "status": "CA" }, { "total": 15916.0, "status": "PE" } ] I need to realize the difference of PE status - (CO + CA). The…