Within my collection, there are various documents that store information about individuals:
{
name : 'Peter'
city : 'New York'
dogs_owned : 2,
cats_owned : 1,
}
{
name : 'Amir'
city : 'Chicago'
}
{
name : 'James'
city : 'Chicago'
dogs_owned : 3
}
{
name : 'Leilani'
city : 'Chicago'
cats_owned : 3,
}
I am looking to create a find query that will retrieve documents where either the "cats_owned" or "dogs_owned" field exists and another condition is satisfied.
Specifically, I want to fetch the documents that have either cats or dogs owned, combined with the condition that the city is Chicago.
Consequently, the query should return the records for James and Leilani in the example above. This operation will be carried out using the node driver for MongoDB.