How can I query collections within my region object? My portfolios region contains objects of Portfolio, which in turn has a List<Position>.
select distinct pos.id from /portfolios p, p.positions.values pos returns UNDEFINED. But http://geode-docs.cfapps.io/docs/developing/querying_basics/query_basics.html <http://geode-docs.cfapps.io/docs/developing/querying_basics/query_basics.html> says I can search collections. Question 1) Why am I getting Undefined? Does the collection need to be other than List ? Question 2) How far can I go with nested collections? If my Position contains a List<Holding>, can I do select distinct h.id from /portfolios p, p.positions.values pos, pos.holdings.values Thanks, Wes
