Re: Querying on nested MongoDB document

2016-08-15 Thread Kasper Sørensen
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

Querying on nested MongoDB document

2016-08-15 Thread Shahan
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