I have a document like this { "_id" : ObjectId("6228cd8e72e74fa2a4bbd76c"), "userId" : 8426, "answer" : "https://cdn.upgrad.com/resumejyotiranjana.docx", "updatedAt" : ISODate("2022-06-09T13:48:17.296Z"), "questionIdentifier" : "resumeLink", } I need to convert answer into array of objects, The existing answer will become resumeLink properties and…
I'm making an aggregation and making 3 $lookup in 3 differents collections to get a collection where the location is . The problem is : I cant do a $geoNear after the first stage of the pipeline. So I tried…
Supposed I have a data of [ { "_id": "629eb5ced774223d36a68907", "userId": "629eb22698df1015e980a98f", "posts": [ { "_id": "629eb59ad774223d36a688fa", "title": "titletestz", "body": "bodyz", "createdAt": "2022-06-07T02:19:06.314Z", "updatedAt": "2022-06-07T02:19:06.314Z", "__v": 0 }, { "_id": "629eb59ad774223d36a688fc", "title": "titletestx", "body": "bodyx", "createdAt": "2022-06-07T02:19:06.879Z", "updatedAt": "2022-06-07T02:19:06.879Z", "__v":…
I have a collection called "Image", below is 1 document of the Image collection: { "_id" : ObjectId("6234342df8afb4001e279ecc"), "is_deleted" : false, "labels" : [ { "_id" : ObjectId("623d687e745109001e09f146"), "labelId" : ObjectId("623d6821745109001e09f04e"), "xmin" : 0.400763358778626, "xmax" : 0.614503816793893, "ymin" : 0.694300518134715,…
Inspired by another question, suppose I have documents that contain an array of events, where each event has 3 fields: eventName, actorId, and detail: { _id: ObjectId("5a934e000102030405000000"), date: ISODate("2022-06-03T00:00:00.000Z"), events: [ { eventName: "Add", actorId: "1", detail: "new actor" },…
I had a document like this: const myUser = 'e' //Collection Selection { level: [ { currentUser: 'f', stages: [ { users: ['a','b','c'] }, { users: ['b','d','e'] } ] }, { currentUser: 'g', stages: [ { users: ['y','x','w'] }, {…
I have several documents, I want to remove the alphabet from the data field, based on the 1st _ in the data field, please see the following output. and if the data is empty the get message "Not Auto found".…
I have a collection of 1000 documents like this: { "_id" : ObjectId("628b63d66a5951db6bb79905"), "index" : 0, "name" : "Aurelia Gonzales", "isActive" : false, "registered" : ISODate("2015-02-11T04:22:39.000+0000"), "age" : 41, "gender" : "female", "eyeColor" : "green", "favoriteFruit" : "banana", "company" :…
Let's say I have the following collection with _id and traits. [ { _id: 1, traits: { Rarity: { infoin: 15, }, Type: { iron: 3, sliver: 5, wood: 7, }, }, }, { _id: 2, traits: { Cloth: {…
I'm trying to get a list of current holders at specific times from a collection. My collection looks like this: [ { "time": 1, "holdings": [ { "owner": "A", "tokens": 2 }, { "owner": "B", "tokens": 1 } ] },…