You have to iterate over the collections (similar to join) to get the values stored in those collection.
Querying nested collections: The following query uses Positions of type HashMap. SELECT p, pos FROM /exampleRegion p, p.positions.values pos WHERE pos.secId = 'VMW' You can find the object definition and more info at: http://gemfire.docs.pivotal.io/geode/getting_started/querying_quick_reference.html -Anil. On Thu, Aug 3, 2017 at 9:12 AM, Anton Mironenko <[email protected]> wrote: > Hello, > > Is there any way to see in gfsh the whole object stored under some key? > > > > Currently only primitive types are printed, but collections are not, only > the collection class name is printed instead (class java.util.ArrayList , > class java.util.HashMap): > > > > gfsh>query --query="select * from /templates where id=3149421226118643712L" > > Result : true > > startCount : 0 > > endCount : 20 > > Rows : 1 > > id | operatorId | eventTypeId | typeID | language > | channelTypeCode | roleCode | subjectTemplate | messageTemplate | > templateEndpointProperties | properties > > ------------------- | ---------- | ------------------- | ------ | -------- > | --------------- | -------- | --------------- | --------------- | > -------------------------- | ----------------------- > > 3149421226118643712 | 0 | 3149421206701113344 | 6 | 14 > | 5 | 1 | | | class > java.util.ArrayList | class java.util.HashMap > > NEXT_STEP_NAME : END > > > > Anton Mironenko > > Software Architect > > Amdocs ASP team > > > This message and the information contained herein is proprietary and > confidential and subject to the Amdocs policy statement, > you may review at https://www.amdocs.com/about/email-disclaimer >
