mongoTemplate fillter document array

Question

Using mongoTemplate in java Spring I tried this, but I don't keep document structure

Document as:

{

   A :'a',
   B :'b',
   C : [
          { 
            name:'cat' ,  type :'animal'
          },
         { 
            name:'jonh' ,  type :'human'
          }
       ]
}

I want to keep document structure and filter c.type = 'animal' like below

Result example :

{

   A :'a',
   B :'b',
   C : [
          { 
            name:'cat' ,  type :'animal'
          },
         
       ]

}

Answer 1

I think you are looking for this query where the document is not modified except for the filtering elements into C array where type is not animal.

So using MongoTemplate you can try something like this (not tested):

Aggregation aggregation = Aggregation.newAggregation(Aggregation.set("C",
    Aggregation.filter("C", Criteria.where("type").is("animal"))
));

List<YourDocumentClass> result = mongoTemplate.aggregate(aggregation, YourDocumentClass.class).getMappedResults();