>> How can I query collections within my region object? >> My portfolios region contains objects of Portfolio, which in turn has a List<Position>
The query in this case is: select distinct pos.id from /portfolios p, p.positions pos No need to call pos.values, as "pos" is a collection. If the query mentioned is from documentation; here it is referring to Positions which is a Map; calling "values" on it returns the collection of map values. >> Why am I getting Undefined? Does the collection need to be other than List ? UNDEFINED. A special literal that is a valid value for any data type. An UNDEFINED value is the result of accessing an attribute of a null-valued attribute. Note that if you access an attribute that has an explicit value of null, then it is not undefined. For example if a query accesses the attribute address.city and address is null, the result is undefined. If the query accesses address, then the result is not undefined, it is NULL. >> 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 There is no limit with access to nested path... -Anil. 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 > > >
