How to get the specified object fields from array in spring mongo using MongoRepository interface

Question

Json Object

{
    "_id" : ObjectId("5c07afde9bc2e9ab1dfb6c01"),
    "rates" : [ 
        {
            "day" : "Mon",
            "start" : "0900",
            "end" : "1800",
            "found " : "active"
        }, 
        {
            "day" : "Tue",
            "start" : "1800",
            "end" : "0900",
            "found " : "inactive"
        }, 
        {
            "day" : "Fri",
            "start" : "1800",
            "end" : "0900",
            "found " : "inactive"
        }
    ]
}

I used below link to get one of the object from array:

get the specified fields from array

When I query like

myRepositroy.findByDayAndTime("Fri"));
public MyStatus findByDayAndTime(String day) {
// i get required object 
Query query = new Query();
        query.addCriteria(Criteria.where("rates.day").is(day));
        query.fields().include("rates.$");

return mongoTemplate.find(query, MyStatus.class);
}

Calling repository to find required object from array with multiple fields

myRepositroy.findByDayAndTime("Fri","1800"));

Below is the method used for querying on multiple fields like

public MyStatus findByDayAndTime(String day,String start) {
 Query query = new Query();            
query.addCriteria(Criteria.where("rates.day").is(day).and("rates.start").is(start));

        query.fields().include("rates.$");

        return mongoTemplate.find(query, MyStatus.class);
    }

but I am getting as a output 2nd index array object instead of 3rd index array object.

How do I get the only required object from array by using query with values like ("Fri","1800")

score 0 · Answer 1 · answered Dec 16 '18 at 12:12

Problem into query. Just replace with this code

public MyStatus findByDayAndTime(String day,String start) {
  Query query = new Query();            
  query.addCriteria(Criteria.where("rates").elemMatch(Criteria.where("day").is(day).and("start").is(start)));

  query.fields().include("rates.$");

  return mongoTemplate.find(query, MyStatus.class);
}

It's working for me. Good to have go with doc mongodb official doc Projection Operator

How to get the specified object fields from array in spring mongo using MongoRepository interface

1 Answers1