1.) I believe it's because the example query is querying against a map. I think this should work:
select distinct pos.id from /portfolios p, p.positions pos 2.) I don't think we have a cap for how deep you can nest collections. On Wed, Jul 15, 2015 at 2:33 PM, Real Wes Williams <[email protected]> wrote: > 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 > > >
