0

I've an data in a collection as below.

{
"date":"01-01-2014",
"details": [ 
    {"name":"abc", 
     "address":{
         "city":"abc" , "state":"abc"
               },
    {"name":"xyz", 
     "address":{
          "city":"xyz" , "state":"xyz"
               }
    }
  ]
}

I want all records having city as "abc" . I am using Java.

I tried below queries and the output is null.

Query searchQuery = new Query();
searchQuery.addCriteria(Criteria.where("details.address.$.city").is("abc"));

and

searchQuery.addCriteria(Criteria.where("details.address.city").is("abc"));

Any help greatly appreciated!!

Philipp
  • 67,764
  • 9
  • 118
  • 153
madhuram2468
  • 41
  • 1
  • 5

0 Answers0