Hi Shahan, We do have a function, MapValueFunction, which can be used for this. Unfortunately I don't think that our MongoDB connector will push it down to the backing query though. So if you query like
SELECT MAP_VALUE(contact, "address.city") FROM customer Then it will functionally work, but it will in deed fetch the complete "contact" document from the DB. Same thing with WHERE clauses etc. Kasper 2016-08-15 9:47 GMT-07:00 Shahan <mail.sha...@gmail.com>: > Hi MM Team > > I have query regarding MM and MongoDb, it will be helpfull if you can > answer these or redirect to correct forurm. > Is there any way to query on nested documents in Apache MetaModel when > using MongoDb as datasource. > > Example we have One collection, Customer which have Items as nested > document. > Is there a way to include sub-documents filed in aggregation functions > such as Count,Avg and Max. > Can we include sub-documents fields in where clause or select clause. > > Thanks > Ss >