I need assistance with querying my MongoDB database:
Specifically, I want to retrieve data that is nested within an array and filter it based on a specific key within the nested structure.
The example document looks like this:
[
{
"name": "PharmaMaria",
"country": "Spain",
"currency": "EUR",
"medicines": [
{
"name": "Medicine 1",
"type": "Suncream",
"price": 32,
},
{
"name": "Medicine 2",
"type": "Suncream",
"price": 5
},
{
"name": "Medicine 3",
"type": "Pills",
"price": 7
}
]
}
]
My goal is to extract data similar to the following by filtering using medicines.type
values = [
{
"name": "Medicine 1",
"price": 32
},
{
"name": "Medicine 2",
"price": 5
}
]
You can explore the query in action at this Mongoplayground link: https://mongoplayground.net/p/_riatO8PKVp
Thank you for your help!