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 },…
i have a collection of category and a collection of products, each product has a categoryId field that has an id of a perticular category. I want to know how many products are there for each category. const categorySchema =…
Given this collection of courses, there is a list of subjects that are composed of objects. Is it possible to create an aggregation to create a new field newSubjects that maps all subjects by their ids? For example, given this…
const score_schema = mongoose.Schema( { tester_id: { type: mongoose.Schema.Types.ObjectId, ref: "user", required: true, }, test_id: { type: mongoose.Schema.Types.ObjectId, ref: "test", required: true, }, score: { type: Number, required: true, }, }, { collection: `score`, timestamps: true, } ); query 1:…
Essentially, there are 2 queries. The first one queries a collection_A and then return an array of _id. The second query will use this array in a $in operator to query collection_B. How can this be done in just 1…
I have a collection with products with structure like this: { _id: 01, user_id: 10, line_items: [ { _id: 2, quantity: 2, }, { _id: 3, quantity: 1, } ], purchase_date: 2021-02-05T21:00:00.000+00:00 } How can I find out how many…
I have a document that looks like this { "_id": { "$oid": "6187e5fa4ebcc2db6c86081f" }, "publicId": "S23DCL", "flights": [ { "name": "f1", "_id": { "$oid": "620026293fc350024da614dd" }, "wines": [ { "id": "1", "name": "wine1" }, { "id": "2", "name": "wine2" }…