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" }…
I have the following schema: User: { ...otherFields, isDumb: false, type: "A" // could be "A", "B", or "C" } I want to fetch all dumb users by default and fetch by type only if the type is passed through…
How can I get only objects in the sales array matching with 2021-10-14 date ? My aggregate query currently returns all objects of the sales array if at least one is matching. Dataset Documents { "name": "#0", "sales": [{ "date":…
I have one document for blogpost like this: { "_id": "5d8051cdf0b1017da7bff23c", "description": "<p>will update soon</p>", "topic": "How to setup Kafka Cluster on CentOS", "comments": [ { "created_at": "2019-10-12T02:13:01.859Z", "updated_at": "2019-10-12T02:13:01.859Z", "edited": false, "_id": "5da182aa013d12567e340a2d", "message": "test" "replies": [ { "created_at":…
I have documents that contains a tags fields. It's a simple array with tag names inside, no object nor _id inside. Just plain tags like this ["Protocol", "Access", "Leverage", "Capability"]. And in my group pipeline I tried something like 'selectedTags':…