I only want to see matching documents, i.e. only T3 in the example below. I can find the matching documents between lotterytickets (many documents) and lotterydrawing (only a few documents). How can I filter out the non-matching documents? Basically, I'd…
I have a large collection I'm searching through on mongodb. (Supports PCRE v8.42) Let's say I'm trying to find where "comment" contains "alpha bravo" where the field value of "name" doesn't immediately follow In other words, match $regex: "alpha bravo…
I'm trying to implement a dynamic search for a huge product collection. The object has several properties including productName, subCategoryName, categoryName, brandName, etc. The user could search for products using any of these properties. The order is fixed and the…
I have a large script, the following section is the relevant part, but if people prefer I can post the whole script on request. The script iterates through a list, looking for a field called colour and renames it color.…
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:…
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…
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 have this document as part of an Aggregation Pipeline: [ { "mfe_average": [ [ true, 5.352702824879613 ], [ false, 3.2361364317753383 ], [ null, 2.675027181819201 ] ] } ] How to convert to this format? Only the true values are…
const search = await searchAgent.aggregate([ {$match: {id: Number(fid), status: {$regex: status, $options: 'i'}}}, {$sort: {[order_by]: order == 'desc' ? -1 : 1}}, {$skip: skip}, {$limit: pagelimit}, ]) Here I need to get the total number of documents matching the query.…
I have an aggregation pipeline that returns 20 tuples with known _id's: [ { _id: 'AA', value: 5 }, { _id: 'CD', value: 2 }, How to create a pipeline stage to order them in an arbitrary order? For example…