I'm a learner and new at mongo. I'm trying to fetch the last records according to particular field. In SQL select * from powerandlevel group by deviceId order by desc limit 1. So in this SQL query based on deviceId…
I have those documents : {"_id" : 1, "actors" : [{"matricule" : "AVB", "name":"XXX"}, {"matricule" : "AVB", "name":"YYY"}]} {"_id" : 2, "actors" : [{"matricule" : "PMH", "name":"FFF"}, {"matricule" : "BNG", "name":"HHH"}]} I would like to get only the first document…
Here's my schema { _id : Number, user1: { _id : Number, userDetail : { userId : Number, userResult : String, } }, user2 : { _id : Number, userDetail : { userId : Number, userResult : String, } },…
I need to filter a multi-level nested array in MongoDB. The schema is as follows, { "_id": "1234", "array1": [ { "id": "a11", "array2": [ { "id": "a21", "array3": [ { "id": "a31", "status": "done" }, { "id": "a32", "status":…
I am very new in MongoDB. I am trying to make lookup in multi label nested array. My data is looks like bellow. [ { "_id": "621eedae92979fd8f0e9451d", "name": "Pallab Koley", "shifts": { "_id": "62636b9fcbda6d2b17f5cae0", …
I want to filter the dataset to extract documents which were created 7 days ago OR a Month ago OR Documents created at any date. filter documents based on createdAt field in document. Dataset:- [ { "_id": ObjectId("6257047cffd61ab62864c1ae"), "type": "A",…
Say we have a collection with this document structure { "full": <string>, "first": <string>, "last": <string> } Looking for an expression in $project with the following logic if ("$full" is null or absent) concatenate ("$first", "_" , "$last") else "$full"…
I have this kind of collection named 'Message' [ { _id: new ObjectId("62641aea1fbe19349f8fba78"), text: 'Hello', user: new ObjectId("625b8f00e2464fb758263b4d"), receiver: new ObjectId("62638d3e5bcd98e7e48ca1b7"), createdAt: 2022-04-23T15:27:38.270Z, updatedAt: 2022-04-23T15:27:38.270Z, __v: 0 }, { _id: new ObjectId("6264256fc0ee5093f8d994a0"), text: 'Hi', user: new ObjectId("62638f1495b841266161b032"), receiver: new ObjectId("62638d3e5bcd98e7e48ca1b7"),…
I am trying to fetch the details from the MongoDB where value of a particular attribute is either a or b. For example, In my collection Test(Attr_A, Attr_B, Attr_C) get the record where value of Attr_C is either "x" or…
I wish to find out all the matching documents in a collection for which the MatchCondition is false. I am trying to do this in the aggregate pipeline using match operator but that is not working. { "_id": { "$oid":…