I have a MongoDB collection containing documents like these: { "id": "62cd5de762c595905e37821b", "letterNo": "122233", "letterDate": "2023-03-01", "metaData": { "name": "test", "family ": "test" } }, { "id": "62cd5de762c595905e37821a", "letterNo": "122233", "letterDate": "2023-03-01", "metaData": { "type": "xxxx", "where": "test" } }…
I have a collection which has one of the fields in it as a nested dictionary. Sample: { "_id": ObjectId(""), "family_member": { "mother":{ "name": "Mary", "age": 40, "address": { "city": "Dover", "state": "Delaware", "zip_code": "19901" } }, "father":{ "name": "John",…
Schema: { img: // array of minimum length 1 of ObjectIds or field is "missing" to indicate that array is empty tar: [ { img: // array of minimum length 1 of ObjectIds or field is "missing" to indicate that…
In my data, one of the fields is an array and I want to return only a section of that array, and only that, no more fields. But when I'm using the $slice in projection, it will return all the…
I have been using .explain("executionStats") to find the execution time for a get-call like below in mongoDB compass console sh: db.getCollection('Employee').find({"value.attendence":{$elemMatch:{"$lt":"2023-03-11T08:49:00Z","$gt":"2023-03-11T08:51:00Z"}}}).explain("executionStats") This works fine. However now I want to see the update timings and not finding a proper query. I…
I have the following documents in my MongoDB Aggregation stage: _id: ObjectId('641316fd596514e63a2121ca'), teamId: 5, playerId: ObjectId('64131139596514e63a2121c1') _id: ObjectId('641316fd596514e63a2121ca'), teamId: 5, playerId: ObjectId('64143f7702ede13fea5ff3be') _id: ObjectId('64143f458b6a6cf54652d3a5'), teamId: 17, playerId: ObjectId('64143fa75a97b9a63a260e16') _id: ObjectId('64143f4f9ba5f2b3cf3030e6'), teamId: 3 I want to create an Object field called…
I have the following two collections, Player and Team. These two collections each contains lots of documents. Here is an example with some dummy data: Player _id: ObjectId('6098c5ab615d9e23543d0f6e'), name: 'Frank', age: 27, position: 'striker' _id: ObjectId('61409537c4f113354782eea3'), name: 'Jan', age: 19,…
I have a db with 80,000 documents in it and each document has a field named Location like below: Location: "82 Some Street | Gautham PS M1M 1M1" This address field is repeated in many documents. I want to do…
Looking for way to directly query a MongoDB index, instead of the collection that the index belongs to. For example, here are two collections: User: { id: ObjectId(), username: string ... } SpecialUser: { id: ObjectId(), specialUsername: string ... }…
Assume I have a collection, things, with the following documents: [ { "_id": 1, "name": "one", "others": [2, 3] }, { "_id": 2, "name": "two" }, { "_id": 3, "name": "three" }, { "_id": 4, "name": "four" } ] As…