I have a document of the form: { "employee_addr": { "city": "London", "street": "Downing Street", "apartment": 10 } "age": 58, "name": "Boris" } I want to flatten the document. That is, removing the employee_addr nested object and moving its properties…
My MongoDB looks something like this : {"_id": "1234aa", "maturity_dt":"2022-07-10", "countryCode":"BLG"}, {"_id": "123ab", "maturity_dt":"2022-07-30", "countryCode":"BLG"} Note that maturity_dt is a string. I want to fetch the records with maturity_dt lesser than Today's date. Please help me build a query with…
db.collection.aggregate([ .... { $group: {_id: "$data.r.id", "col": {$first: "$data.r"}}}, {$project:{"o":{"$objectToArray":"$col"}}}, {$unwind:"$o"}, {$group:{"_id":null, "keys":{$addToSet:"$o.k"}}}, {$project: {"keys":1, "_id": 0}}, {$addFields: {res:{$map:{ input:"$keys", as: "a", in: {"_id":0,"label": "$$a"}}}}}, {$project: {"res":1}} ]) With my MongoDB query, the output is: { "res" : [ {…
I have a sample collection of documents in mongo db like below [{"name":"hans","age":30,"test":"pass","pre":"no","calc":"no"}, {"name":"abs","age":20,"test":"not_pass","pre":"yes","calc":"no"}, {"name":"cdf","age":40,"test":"pass"}, {"name":"cvf","age":30,"test":"not_pass","pre":"no","calc":"yes"}, {"name":"cdf","age":23,"test":"pass"}, {"name":"asd","age":35,"test":"not_pass"}] For some documents the fields pre and calc are not present. I want to add those two fields to the documents which…
I have two collections one is for posts (PostInfo) and one for users (UserInfo), I join two collections and I want to find the posts if the given userid is in AsUser.Friends : var docs = await _dbContext.PostInfos.Aggregate() .Lookup("UserInfo", "UserId",…
I have the following document type: { "_id": 1, "_a": [ { "_aId": { "CC": "CA" }, "_p": [ { "_pId": { "CC": "CA", "SN": 1 }, "s": { "c": { "t": [ { "sId": 1, "language": "CA", "format": "A4"…
I have the following aggregation stage that I'd like to add to my pipeline, but it keeps failing. When I use the MongoDB Compass Aggregation GUI, everything works as it should. I even exported that pipeline from the GUI and…
I am pulling data from 2 collections as shown in this MongoDB playground. While pulling the data from the second collection, I want to create a match on tag, such that only those posts are returned that have the particular…
I've following schema { "_id" : ObjectId("xxxxx"), "updatedAt" : ISODate("2022-06-29T13:10:36.659+0000"), "createdAt" : ISODate("2022-06-29T08:06:51.264+0000"), "payments" : [ { "paymentId" : "xxxxx", "paymentType" : "charge", "paymentCurrency" : "PKR", "paymentMode" : "cash", "paymentTotal" : 13501.88, "penalties" : 100 }, { "paymentId" : "ccccc",…
Suppose there is a MongoDB Collection CollA. Say CollA has the following three Documents: {"_id": "1", "name": "Bob"}, {"_id": "2", "name": "John"}, {"_id": "3", "name": "Will"} Let's say there is another MongoDB Collection CollB which has the following Document: {…