when i run my ruby script which insert a multiple Json array inside a multiple documents, occur an issue: "MONGO::Error::MaxBSONSize : The document exceeds maximum allows BSONB object after serialization". How can i solve this problem please? i had no…
I have mongo documents like below, want to perform aggregation to find the errorcodes count for each unique contacts. { "_id": { "$oid": "" }, "campId": "61baef7817cd8ff66518", //camp1 "contactId": "61aa6fbf77490b0007714273", // contact 1 "title": "Happy Holidays!", "communicationType": "EMAIL", "contactedOnTime": {…
compound index { A: 1, B: 1 } In this query, the compound index is not used: db.user.aggregate([ { $match: { B: { $gt: 100 } } }, { $sort: { A: 1 } }, { $limit: 1000 } ])…
How can I write a mongo query to filter today's record with time when I have date and time in string in json object in mongo. My Json Object is { "_id": "" "data_id": 3227, "series_id": 240, "date_wise": "17 Sep…
I am having issues with projecting some fields with mongodb $project my colection has the following datas [{num:"SI-0101",mob:6289141515},...] and my $project query [{ $project: { "Id No.": "$num", "Mobile No.": "$mob" // note on that ., i need it in…
I would like to all documents which the last event of category Temperatures is technicalFailure even if there are other events after this one. To give more context, the query is the result of a http request with query parameters.…
I'm trying to find all unique strings of some subdocument in MongoDB, as long as at least one of them contains a certain substring. These strings are localized though. I want to have the results for all possible languages. So,…
If there are documents with endDate,I want to fetch documents in a collection whose endDate+3 days is less than today through mongo query The below query will find records whose endDate is less then today const myCollection= DB_CONNECTION.collection(TRANSACTION); let expiredTrans…
I have following data in my collection { “name": “test”, "data": { “statusOne”: “enabled”, “statusTwo”: “active” } } { “name": “test”, "data": { “statusOne”: “disabled”, “statusTwo”: “active” } } { “name": “another-test”, "data": { “statusOne”: “disabled”, “statusTwo”: “active” } }…
Our DB has hundreds of thousands of rows of data where a particular entity amasses points in a certain entry based on certain constraints. Let us call the entities A1, A2…A1000. Let the constraints be X1, X2, X3…Xn. The constraints…