I have a documents like below. I want to retrieve all documents whose address.city == "newyork" and address.id == active. [ { "name": "star1", "active": 1, "address": [ { "id": 1, "city": "newyork" }, { "id": 2, "city": "sydney" }…
I have a a mongo db table in the following format [{"url":"www.example1.com", "name":"hans","age":30}, {"url":"www.example2.com", "name":"x","age":34}, {"url":"www.example3.com", "name":"y","age":35}, {"url":"www.example4.com", "name":"z","age":36}, {"url":"www.example5.com", "name":"b","age":37}] I have two tables where i need to check for under two if conditions. I did in the following…
This is my first question ever here so super excited to learn and apologies if the syntax is not up to mark, I will improve with time. "item" is an Array ( this doc has only one element) "adjudication" is…
Basically, I have 2 collections in my MongoDB database -> Books, Scores. Books { "BOOK_ID" : "100", "BOOK_NAME" : "Book 1", "BOOK_DESC" : "abcd", }, { "BOOK_ID" : "101", "BOOK_NAME" : "Book 2", "BOOK_DESC" : "efgh", }, { "BOOK_ID" :…
I am using pymongo . I need to run db.getUsers() in pymongo. Is there any documentations to do so. I only saw the pymongo commands . There doesn't seems to run mongoshell commands using pymongo and retrieve data If any…
I have searched a lot to use groupby based on the array field value, but I didn't get proper results in google, so I'm posting here. I have tried my best, it works 50% need to correct my query can…
I am having mongo collection like below, { "_id" : ObjectId("62aeb8301ed12a14a8873df1"), "Fields" : [ { "FieldId" : "e8efd0b0-9d10-4584-bb11-5b24f189c03b", "Value" : [ "test_123" ] }, { "FieldId" : "fa6745c2-b259-4a3b-8c6f-19eb78fbbbf5", "Value" : [ "123" ] }, { "FieldId" : "2a1be5d0-8fb6-4b06-a253-55337bfe4bcd", "Value" :…
"ParentType": { "Food": [ { "Name": "Burger", "FoodId": "5e3abe145c1bfb31b4e335de", "Price": 0, "Quantity": 1, "SubCategory": 0 } ], "Inventory": [ { "Name": "Small Popcorn", "InventoryId": "5e3a64245c1bfb31b4e335b7", "Price": 0, "Quantity": 1, "SubCategory": 0 } ] } I need to add UOM as…
Test Data:- professor:{ name:"temp1", department:[ {name:"pro1", review:[ {paper:"paper1",status:"review",paperid:"1"} ]}]} I want to update the status "review" to "finish". For to search I use : { department: { $elemMatch: { review: { $elemMatch: { paperid: id } } } }}
Please help me. I have a collection as below [ { "_id":{ "$oid":"62a3673660e2f16c7a7bc088" }, "merchant":{ "$oid":"62a3640560e2f16c7a7bc078" }, "title":"24 Test 1", "filter_conditions":{ "city":[ "AAA", "BBB", "CCC", "DDD" ], "state":[ ], "pincode":[ "12345" ] } }, { "_id":{ "$oid":"62a3673660e2f16c7a7bc089" }, "merchant":{ "$oid":"62a3640560e2f16c7a7bc079"…