A collection has an indexed involved field_A. But field_A is not required. So what happens if some documents do not have this field? Will the index still work for documents that do have this field?
I have the following Mongodb document. { "_id" : ObjectId("62406bfaa1d66f8d99c6e97d"), "skill": "Programming Language" "supply" : [ { "employeeName" : "A1", "skillRating" : 3 }, { "employeeName" : "A2", "skillRating" : 4 }, { "employeeName" : "A3", "skillRating" : 4 },…
I'm trying to do a lookup from collection1 to collection2 using attachments.collection2_keys (an array), and at the same time filter collection1 where collection2.type is typeA, for any key in attachments.collection2_keys. I believe this query should work, but it returns no…
I am trying to update the name of a key inside an object of an array and annoyed due to the inability to make the queries work. I have tried this How rename nested key in array of object in…
I have a MongoDB document with the following attributes: { "label": [ "ibc", "ibd", "ibe" ], "location": "vochelle st" } and I have to return the document only if the documents label exactly matches the given array i.e., ["ibc","ibd"] and…
I have a collection with products with structure like this: { _id: 01, user_id: 10, line_items: [ { _id: 2, quantity: 2, }, { _id: 3, quantity: 1, } ], purchase_date: 2021-02-05T21:00:00.000+00:00 } How can I find out how many…
I'm trying to generate ObjectId() when inserting manually in Robo 3T. Code below seems doesn't work. I wanted every object inside TestArray have a unique id. How do I generate ObjectId manually? { "Name" : "Test", "TestArray" : [ {…
{ _id: "d473ad718f214f158b31d591a97a5ce7", name: 'sam', keys: { q8f3ff57b03940959e1ae4dfe2cb57ad: { serviceaccountkey: { keyID: 'q8f3ff57b03940959e1ae4dfe2cb57ad', status: 'ACTIVE', keytype: 2, } }, m887f7854adb4907b57903b896bcf6d6: { serviceaccountkey: { keyID: 'm887f7854adb4907b57903b896bcf6d6', status: 'ACTIVE', keytype: 2, } } } } } Suppose this is a document. How…
I am trying to get the 100 documents from my DB based on the sum a few fields. The data is similar to this: { "userID": "227837830704005140", "shards": { "ancient": { "pulled": 410 }, "void": { "pulled": 1671 }, "sacred":…
Questions are How many products have a discount on them? How many "Water" products don't have any discount on them? How many products have "mega" in their name? How many products have discount % greater than 30%? Which brand in…