In my MongoDB collection, I have multiple records. Each record contains an array with objects that have various fields.
Here is the structure of my collection:
[{
"name" : "Karthik Thurairaja",
"universities" : [
{
"name" : "Anna University",
"city" : "Chennai"
},
{
"name" : "Punjab University",
"city" : "Chandigarh"
},
{
"name" : "University of Delhi",
"city" : "New Delhi"
}
],
},
{
"name" : "Sathish Kumar",
"universities" : [
{
"name" : "Anna University",
"city" : "Chennai"
},
{
"name" : "University of Hyderabad",
"city" : "Hyderabad"
},
{
"name" : "University of Delhi",
"city" : "New Delhi"
}
],
}]
I want to retrieve all the records where the city of universities is equal to Chennai.
This is the query I attempted:
Collection.find({ "universities.city": "Chennai" }).exec(...);