I have an array of objects in my company collection holding grouped values as follows: "groups" : [ { "id" : "d278c44333", "name" : "group 1" } ], so in mongoDB it would be company > groups > 0 >…
I'm trying to join or call only one document from multiple documents that can be repeated, all this for a unique identifier, in this case code, which is a numerical value. [ { "_id": "6386b0e114fe6aee844af06e", "transfer": { "code": 2, "author":…
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":…
Hi How would I be able to convert millisecond to HH:MM:SS format in mongodb? Below is my sample data. { "Item":"Test1", "millisecond" : 188760000 }, { "Item":"Test2", "millisecond" : 23280000 }, { "Item":"Test3", "millisecond" : 128820000 }, Expected output will…
I have collection: bookSchema as: [ { _id: ObjectId("637d05dc32428ed75ea08d09"), book_details: { book_name: "random123", book_auth: "Amber" } }, { _id: ObjectId("637d0673ce0f17f6c473dee2"), book_details: { book_name: "random321", book_auth: "Amber" } }, { _id: ObjectId("637d069a3d597c8458ebe4ec"), book_details: { book_name: "random676", book_auth: "Amber" } }, {…
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…
I have a collection of docs like {'id':1, 'score': 1, created_at: ISODate(...)} {'id':1, 'score': 2, created_at: ISODate(...)} {'id':2, 'score': 1, created_at: ISODate(...)} {'id':2, 'score': 20, created_at: ISODate(...)} etc. Does anyone know how to find docs that were created within the…
I have a MongoDB collection like this: { _id: "abc", history: [ { status: 1, reason: "confirmed" }, { status: 2, reason: "accepted" } ], _id: "xyz", history: [ { status: 2, reason: "accepted" }, { status: 10, reason: "cancelled"…
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…
I was working with the MongoDB Atlas Server... and encountered this error... What does it mean...? Can someone explain in simple words plz... This was the query i was trying... db.posts.find({}, {title: 1, date: 0}) The structure of the posts…