I trying to match the data in Subarray for some reason it is grouped like this. Data : { "_id": 1, "addresDetails": [ [ { "Name":"John", "Place":"Berlin", "Pincode":"10001" }, { "Name":"Sarah", "Place":"Newyork", "Pincode":"10002" } ], [ { "Name":"Mark", "Place":"Tokyo", "Pincode":"10003"…
I have a document with format like this: { "f1": "v1", "f2": { "id": 1, "sub": "subv", "updatedAt": 123 } } I have an another source that give me a inputf2 object. I want to write an upsert query to…
I've been trying to create a query on documents like these: [ { "timestamp": new ISODate('2020-01-01T00:00:00'), "objectId": "Id_A", "locationId": "Location_A" }, { "timestamp": new ISODate('2021-01-01T00:00:00'), "objectId": "Id_A", "locationId": "Location_A" }, { "timestamp": new ISODate('2022-01-01T00:00:00'), "objectId": "Id_A", "locationId": "Location_B" }, {…
I have a collection like this: { '_id' : ObjectId('6251f8556e75125f9260f333'), 'name': 'jojo', 'profile': 'jojo profile', 'date': ISODate("2022-04-09T21:18:40.473Z"), 'look': [ { 'art': 'group-id', 'data': 'alma', 'dt': '1'}, { 'art': 'called', 'data': 'central', 'dt': '1'}, { 'art': 'access-time', 'data': 108000, 'dt': '1'}…
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:…