Am trying to create a poll results aggregation I have two collections poll - here is one document { "_id": { "$oid": "636027704f7a15587ef74f26" }, "question": "question 1", "ended": false, "options": [ { "id": "1", "option": "option 1" }, { "id":…
I have an array of strings that are end part of document IDs const arr = ['ace', 'acb', 'acc', 'aca']; const documents = [ { id: 'xxxxxxxace' }, { id: 'xxxxxxxacb' }, { id: 'xxxxxxxacc' }, { id: 'xxxxxxxaca' }…
I have a database of a the employees of a company that looks like this: { _id: 7698, name: 'Blake', job: 'manager', manager: 7839, hired: ISODate("1981-05-01T00:00:00.000Z"), salary: 2850, department: {name: 'Sales', location: 'Chicago'}, missions: [ {company: 'Mac Donald', location: 'Chicago'},…
I have collection with documents, for example: [ { 'id':'1' 'some_field':'test', 'rates':[ {'user_id':'12','rate':'very_good'}, {'user_id':'13','rate':'very_good'} {'user_id':'14','rate':'bad'}, {'user_id':'15','rate':'normal'} ] } ] And i have collection with values of rates in string: [ { "rate_name" : "bad", "rate_value" : 1 }, { "rate_name"…
I need to get two different sets of data from the same collection and if any data in any set has convergence with another data in other set combine them into one and if not convert them to a desired…
I am trying to create a view for records created/modified in last 24 hours. Is it possible? Tried creating view as below db.createView( "viewname", "sourcecollection", [ { $match: {"modifiedTime":{$gte:new Date(Date.now() - 24*60*60*1000), $lte:new Date()}}}] ) But it translates to static…
I have a large collection of JSON documents that has many entries of the following format (contents in my example are important to my question): doc1 { "data": [{ "entry": { "fieldA": "aaa", "fieldB": "xxx" } }, { "entry": {…
i have a document structure like this: { "_id": "...", "shop": "pepe", "fruits": [ { "name": "banana", "taste": "sweet", }, ] } Now i want to change the type of fruits.taste to an array like this: "taste": ["sweet"] So the…
The upsert statement below does not work and get: MongoServerError: E11000 duplicate key error collection: db.emails index: _id_ dup key: { _id: "8hh58975fw" } My goal is to edit an existing document ( or create if exists ) with the…
I have this pipeline : let pipeline = [ { $match: { date: { $gte: new Date("2022-10-19"), $lte: new Date("2022-10-26") }, }, }, { $group: { _id: "$date", tasks: { $push: "$$ROOT" }, }, }, { $sort: { _id: -1…