Database

[{"_id":"1","OfferNumber":"string","ComercialCode":"string","ContractNumber":null,"FirstDocSent":"date","EventDate":"date","EndDate":"date","LastMaintenance":"date","UserMaintenance":"rny","PurgePhysicalDocDate":"date","StoredDocuments":[{"CodeEmission":"string","ItemNumber":"string","DocumentType":"number","DocumentNumber":"number","OriginSystemCode":"rny","StoreDate":"date","IdGed":"number","IdS3":1},{"CodeEmission":"string","ItemNumber":"string","DocumentType":"number","DocumentNumber":"number","OriginSystemCode":"rny","StoreDate":"date","IdGed":"number","IdS3":2},{"CodeEmission":"string","ItemNumber":"string","DocumentType":"number","DocumentNumber":"number","OriginSystemCode":"rny","StoreDate":"date","IdGed":"number","IdS3":3}]}]

Query

db.collection.aggregate([{"$match":{"StoredDocuments.IdS3":1}},{"$replaceRoot":{"newRoot":{"$arrayElemAt":[{"$filter":{"input":"$StoredDocuments","cond":{"$eq":["$$this.IdS3",1]}}},0]}}}])

Result