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" : {…
I'm trying to build MongoDB Atlas full text search index. However, I'm struggle a bit with the analyzers. Here is my index: { "analyzer": "lucene.standard", "searchAnalyzer": "lucene.standard", "mappings": { "dynamic": false, "fields": { "description": { "type": "string" } } }…
So what I want to do is group all documents having same hash whose count is more than 1 and only keep the oldest record according to startDate My db structure is as follows: [{ "_id": "82bacef1915f4a75e6a18406", "Hash": "cdb3d507734383260b1d26bd3edcdfac", "duration":…
I am trying to query a document in my MongoDB Document: { _id: '111', subEntities: [ { subId: '999', dateOfStart: '2098-01-01', dateOfTermination: '2099-12-31' }, { subId: '998', dateOfStart: '2088-01-01', dateOfTermination: '2089-12-31' } ] } My Query: {"$and": [ {"subEntities.dateOfStart": {"$lte":…