Azure cosmos Db Criteria query with subdocuments - java spring boot

Question

I'm new to azure cosmos db. i'm trying to read items from container in my spring boot application. i'm using cosmos template with criteria. lets say i have a document like this
{
"stop_id": 70021,
"stop_name": "CALTRAIN - 22ND ST STATION",
"stop_lat": 37.757692,
"stop_lon": -122.392318,
"zone_id": 3329,
"trip": [{
"trip_id": "RTD8997283",
"arrival_time": "05:40:00",
"departure_time": "05:40:00",
"stop_id": 70021,
"stop_sequence": 1
}, {
"trip_id": "RTD8997283",
"arrival_time": "05:52:00",
"departure_time": "05:52:00",
"stop_id": 70021,
"stop_sequence": 2
}]
}

i can add criteria for stop id like this
Criteria.getInstance(CriteriaType.IS_EQUAL, "stop_id", Collections.singletonList("70021"), Part.IgnoreCaseType.ALWAYS);

But if i want to add criteira for trip id, how can i do it?

Answer 1

Hi @Sibi Sundarrajan , welcome to Microsoft Q&A forum.

Can you please try something like below and see if it works:

Criteria.getInstance(CriteriaType.IS_EQUAL, "trip.trip_id", Collections.singletonList("RTD8997283"), Part.IgnoreCaseType.ALWAYS);  

Please let us know if this does not work and we can look into it further.