I have a large set of records in this schema: { username: "[email protected]", timestamp: 1646006400000 //unix timestamp in milliseconds amount: 100 } Given an arbitrary range of dates, I need to find the change in average amount value vs a…
I am trying to count how many times does a particular value occur in a collection. { _id:1, field1: value, field2: A, } { _id:2, field1: value, field2: A, } { _id:3, field1: value, field2: C, } { _id:4, field1:…
here is my data which I need to add in a collection let data = { 'a':'data a', 'ab':'data a', 'b':'data b', 'c':'data c' } here is my collection data: { name:'xyz', age:'100', arr: ['a','ab'] } what I want: {…
I am using coffeescript with nodejs to query monogodb data but for some custom data i need to perform aggregate function on my collection but using Session.aggregate(query) in the code is giving me error like not pipeline operator $and. So,…
I have an issue that need to insert index number when get data. First i have this data for example: [ { _id : 616efd7e56c9530018e318ac student : { name: "Alpha" email: null nisn: "0408210001" gender : "female" } }, {…
I want to have the mongodb query given these details below, and to have best in performance. Let me start by an example: Let me have a collection, /// the collection services = [ { _id: obj(id1), provider_id: "provider1", service_code:…
I have following json data in mongodb. [ { "_id": 1, "name": "user1", "userActivities": [ { "actionTaken": "Sign in.", "progress": "Success." }, { "actionTaken": "logout", "progress": "Success." } ] }, { "_id": 2, "name": "user2", "userActivities": [ { "actionTaken": "Sign…
I have a collection in this format: { "place":"land", "animal":"Tiger", "name":"xxx" }, { "place":"land", "animal":"Lion", "name":"yyy" } I want to result to be something like this: { "place":"land". "animals":{"Lion":"yyy", "Tiger":"xxx"} } I wrote the below query. I think there needs…
I have the following MongoDB structure: Division Collection: { "_id": ObjectId("5b28cab902f28e18b863bd36"), "name": "Premier League", ... "teams": [ ObjectId("5b28cab902f28e18b863bd01"), ObjectId("5b28cab902f28e18b863bd02"), ObjectId("5b28cab902f28e18b863bd03"), ... ] ... }, ... Teams Collection: { "_id": ObjectId("5b28cab902f28e18b863bd01"), "name": "Liverpool", ... "players": [ ObjectId('5b23tmb902f28e18b863bd01'), ObjectId('5b23tmb902f28e18b863bd02'), ObjectId('5b23tmb902f28e18b863bd03'), ... ]…
I have the following Mongodb document. { "_id" : ObjectId("62406bfaa1d66f8d99c6e97d"), "skill": "Programming Language" "supply" : [ { "employeeName" : "A1", "skillRating" : 3 }, { "employeeName" : "A2", "skillRating" : 4 }, { "employeeName" : "A3", "skillRating" : 4 },…