There is an index on requestedAtTimestamp_-1 but the query regularly takes over 5s and Mongo Atlas is shouting at us saying The ratio of documents scanned to returned exceeded 1000.0. Are there additional indexes that could help to speed up…
I am trying to find hierarchy of documents (Aggregation) from a collection in MongoDB using $graphLookup with keys partOf and contains which are of Object datatype that store array of categories and the _id field inside. Input collection sample (relationships_collection):…
I have a mongoDB Query that uses aggregation. I am applying projection and then unwind. ProjectionOperation projectionPreUnwind = Aggregation.project(Fields.from(Fields.field("result.detections.reference.control", "result.detections.reference.control"))); UnwindOperation unwindOpn = Aggregation.unwind("result.detections"); Aggregation aggregation = Aggregation.newAggregation(projectionPreUnwind, unwindOpn); LOGGER.info(" aggregation {}", aggregation); AggregationResults<String> detectionsDataAggr = mongoTemplate.aggregate(aggregation, CASES_COLLECTION, String.class); The…
Suppose we have a mongodb collection with 6 columns: RoomFrom RoomTo PoolFrom PoolTo FloorFrom FloorTo Now I would like to select rows where range *From / *To intersect with another ranges. For example: [ { _id: 1, RoomFrom: 100, RoomTo:…
I have a nested mongo array { "_id": 1, "date": "2024-09-30", "employees": [ { "_id": 101, "name": "John Doe", "company": "ABC Corp", "department": "HR", "salary": 50000, "contactNumber": "123-456-7890" }, { "_id": 102, "name": "A", "company": "XYZ Corp", "department": "HR", "salary":…
With MongoDB id stored in Java LUUID (legacy representation), when a script is run to retrieve these ids, the output shows them in binary format: var myStringArray = ["string1", "string2"]; for (var i = 0; i < myStringArray.length; i++) {…
in MongoDB I want to group an array of documents that is nested in another document without it affecting the parent document. Database: db={ "users": [ { "firstName": "David", "lastName": "Mueller", "messages": [ { "text": "hello", "type": "PERSONAL" }, {…
Here is my mongo sample collection, { "_id" : ObjectId("62aeb8301ed12a14a8873df1"), "Fields" : [ { "FieldId" : "name", "Value" : [ "test_123" ] }, { "FieldId" : "mobile", "Value" : [ "123" ] }, { "FieldId" : "amount", "Value" : […
I'm trying to upsert a document OR update 2 fields in one round trip with an aggregation (or some variation of one of the many update methods) in mongodb. Example Record I'm trying to upsert: { _id: "1", favoriteColor: "blue",…
I have a data set that I am "mapping" into different names. Using Mongodb 7.0. I am using aggregate I am at the "$project stage { _id: 0, "First Name": "Executive First Name", "Last Name": "Executive Last Name", "Title": {…