Hi Curtis, I don't think that flatten does what I need.
I'm trying to use Orient as a document store where I can save a json object containing other json objects. Then I want to retrieve the top level json object along with the full tree of subobjects. Is it possible to do this? On Thursday, 21 August 2014 16:29:55 UTC+1, Curtis Mosters wrote: > > Hi I think you have kind of these issues: > https://github.com/orientechnologies/orientdb/issues/1332 > https://groups.google.com/forum/#!topic/orient-database/KiT4WoANxUE > > Did you already try to use flatten() on the dataset? > > Am Donnerstag, 21. August 2014 17:20:34 UTC+2 schrieb Brendan Maginnis: >> >> Hi, >> >> We're evaluating whether to use OrientDB at our company. So far it looks >> really great. >> >> We will need to store documents with nested documents within them. >> The schema won't be known until runtime but we need to fetch the full >> nested documents as json >> >> Using the document api in 1.7.8 I can create a document with a sub >> document like so >> ODocument doc = new ODocument("mydoc"); >> ODocument subdoc = new ODocument("subdoc"); >> subdoc.field("name", "Tom"); >> doc.field("subdoc", subdoc); >> doc.save(); >> >> If I then fetch it using the following query >> select * from mydoc where subdoc.name = 'Tom' >> >> and call toJSON on it I get >> {"@type":"d","@rid":"#9:55","@version":1,"@class":"mydoc","subdoc": >> "#14:0"} >> >> >> I would like to retrieve the full nested document including all the >> fields from subdoc >> {"@type":"d","@rid":"#9:55","@version":1,"@class":"mydoc", "subdoc":{ >> "name":"Tom"}} >> >> How would I do this? >> >> Cheers! >> >> >> -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
