I'm trying to do this: I have an array of objects with the detail of a sale, with this format: [ { product:Banana, quantity:34, ...(other fields) }, { product:Apple, quantity:11, ...(other fields) }, { product:Banana, quantity:15, ...(other fields) }, {…
I'm using Azure Service Bus (@azure/service-bus) in a TypeScript-based nest.js service to schedule messages to be delivered at a future point in time. I need to be able to cancel those messages before the delivery date if needed. My plan…
I'm starting to learn Aggregate in MongoDB. I have a simple doc as below, which has 2 fields, name and examScores. examScores is an array containing multiple documents: [ { _id: ObjectId("633199db009be219a43ae426"), name: 'Max', examScores: [ { difficulty: 4, score:…
Here is the query: const tags = await mongo .collection("positive") .aggregate<{ word: string; count: number }>([ { $lookup: { from: "search_history", localField: "search_id", foreignField: "search_id", as: "history", pipeline: [ { $match: { created_at: { $gt: prevSunday.toISOString() }, }, }, {…
Hi I have been trying to figure this error out for two whole days, googling, reading relevant forums in here, but seems I can not solve this error to make my code to fully function. I would appreciate any help…
As the title states, I'm using debezium Postgres source connector and I would like MongoDB sink connector to group kafka topics in different collection and databases (also different dbs to isolate unrelated data) according to their names. While inquiring I…
I am having 2 collections - Collection name is content Collection name is surveys I actually want to add the "type" information from the content collection to every content in every survey in the "surveys" collection. I know in SQL…
I want to delete data from multiple collection based on ids received using match query from aggregation . Currently in python i am doing like this but it is taking a lot of time to execute . motor is used…
I'm trying creating a query to fetch a user's friends list. I already have a solution to this problem, but my method involves using project on every single field in the nested array, so I'm looking for the best way…
Currently, I have 3 different aggregate queries which generate different counts based on grouping of companyRegNo. Is there a way to combine these 3 queries. The employeeActions data looks like this: { "email": "[email protected]", "companyRegNo" : 105, "event" : {…