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":…
I have this collection in my Mongo database: id | place | local time -------------------------- 3 | A | 12pm 4 | A | 11pm 5 | B | 4pm 6 | | 7pm The local times are stored as…
I have a mongodb collection that looks like this: { "_id" : ObjectId("60471bd482c0da3c0e70d26f"), "owner" : "John", "propAvailable" : { "val1" : true } }, { "_id" : ObjectId("60471bd482c0da3c0e76523f"), "owner" : "Matt", "propAvailable" : { "val1" : { "val2" : true…
How to extract json field from query response in node js? I have a query:- const Allposts = await Post.aggregate([pipeline]) Allposts:- { _id: 1, type: 'A', source: 'B', status: 'C', totalCount: 7, createdAt: 2022-04-13T17:12:28.097Z, updatedAt: 2022-04-13T17:12:28.097Z, __v: 0 }, {…
I have an existing collection, containing several documents. [{ "_id": "...1", "prop1": "...", "prop2": "...", "someArray": [ { "value": "sub element 1.1" }, { "value": "sub element 1.2" }, { "value": "sub element 1.3" } ] }, { "_id": "...2",…
Before asking this question I read these answers, but could not find the solution: Check if coordinate is within area Geolocation - Check if a location belongs to an area Check if coordinate in selected area How to calculate intercepting…