Re: Querying on nested MongoDB document

2016-08-16 Thread Shahan
Hi Kasper I tried as suggested by you in select clause. SELECT MAP_VALUE( name, "accounts.account_name") FROM Provider And i tried this also DataSet dataset = dc.query().from(table).select(FunctionType.MAP_VALUE, "accounts", new Object[] { "account_name" }).execute(); I am getting result

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