I am trying to use mongo lookup operator to join data between two collections. I have a collection named parks looking { "_id": { "$binary": { "base64": "5y1dpNaZSEOTJiace1Ta2A==", "subType": "04" } }, "parkID": "9c98c8ee-17a6-4db7-8115-c55fa470480d", } I have another collection named…
I have a bunch of event data which is identified by uid and timestamp. I have a number of aggregation pipelines which will calculate statistics for each user. These work if I run them one at a time, but I…
I have two collection. User and Course User Collection [{ "_id": "11111", "name": "john", }, { "_id": "11112", "name": "smith", }] Course Collection [{ "_id": "00011", "user_id": "11111", "location_id": "9999", }, { "_id": "00012", "user_id": "11111", "location_id": "8888", }, {…
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" }, {…