Hello, I’d like to query a document (using the mongoshell) containing an array of “hotels_booking”. Inside this array, there are several objects containing information about booking. I’d like to retrieve all documents having hotels_booking[n].client.firstName = “limace” ; n being the number of hote…

The way you wrote your query means you want the object hotels_booking.client to be equal to the object {firstName:limace}. The 2 objects are not equals because the hotels_booking.client also has the field lastName. You have to use the dot notation up to the last field like: { "hotels_booking.clie…

Sam_N_A3 (Sam N/A) December 8, 2023, 2:14pm 3

Thank you so much for the answer !! It works

1 Like

Query a document with nested subdocuments